Closing up the Gaps

Hi All.....

I'm a little bit new to Access and Visual Basic. So forgive me if my question seems straight forward.

I want to know how to make controls and/or textboxes and labels appear invisible on the report if no information is entered on the form. But not only do i want them to appear invisible, but i want any information that follows it (in seperate text boxes etc.) to close up the gap and fill the spot of the invisble label and textbox etc.

Is this possible? if so how?

re: Closing up the Gaps

bump..............

re: Closing up the Gaps

making them invisible is easy

If IsNull(Me.textboxName) Then
Me.textboxName.Visible = False
Me.lableName.Visible = False ' textbox caption has to be set separately
Else
Me.textboxName.Visible = True
Me.lableName.Visible = True ' textbox caption has to be set separately
End If

Moving the subsequent textboxes would require resetting the position properties of all textboxes set on a complicated set of conditions. It is really not very practical.

re: Closing up the Gaps

I didnt think it would be :( ........but thanks for the help anyways.