Visible Property

[amylapinsky]

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!

 

[Dirk Goldgar]

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!

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)