Visible/Not Visible on reports

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Using A02. I can use the visible/not visible in event
procedures on forms. But, I have a field on a report that
lays across grid lines and would like to use if null, not
visible so I don't have a blank spot in my grid. Can
anyone tell me if I'm missing something here? I know
getting rid of the grid lines would solve my problem but
they won't let me! They insist on having them.

Thanks in advance for any help or advice!!! I love you
guys!!!
 
Bonnie said:
Using A02. I can use the visible/not visible in event
procedures on forms. But, I have a field on a report that
lays across grid lines and would like to use if null, not
visible so I don't have a blank spot in my grid.
Click to expand...


You can use the section's Format event to make controls
visible or not:

Me.thetextbox.Visible = Not IsNull(Me.thetextbox)
 
Back
Top