Visible Property

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

Guest

I am trying to set the visibility of a text box in an Access report based on
the value of another text box. (i.e. I would like text box A to be hidden if
text box B is blank). Any help is appreciated. Thank you!
 
amylapinsky said:
I am trying to set the visibility of a text box in an Access report
based on the value of another text box. (i.e. I would like text box A
to be hidden if text box B is blank). Any help is appreciated. Thank
you!
Click to expand...

In the Format event of the appropriate section of the report, you would
code an event procedure that wold include code like this:

Me!TextBoxA.Visible = (Len(Me!TextboxB & vbNullString) > 0)
 
Back
Top