Visible/Not Visible on reports

[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!!!

 

[Marshall Barton]

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.

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

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