How do I make a line not visible on a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to make a line visible and not visible on a report based on the result
of the query the report uses. I have a text box called "materiality" and if
it displays a "Yes", I want the line next to it to be visible, if "No", then
I do not want the line visible. I cannot attach any events to the line
itself, so how can I do this? Thanks in advance for any help.
 
jedi008 said:
I wish to make a line visible and not visible on a report based on the result
of the query the report uses. I have a text box called "materiality" and if
it displays a "Yes", I want the line next to it to be visible, if "No", then
I do not want the line visible. I cannot attach any events to the line
itself, so how can I do this? Thanks in advance for any help.


Use code in the Format event procedure of the section
containing the text box and line:

Me.theline.Visible = (Me.materiality = "yes")
 
You can add code to the On Format event of the section containing the
controls

Me.LineControlName.Visible = (Me.Materiality = "Yes")
 
Back
Top