By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,586 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,586 IT Pros & Developers. It's quick & easy.

Closing up the Gaps

P: 3
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?
Aug 3 '06 #1
Share this Question
Share on Google+
3 Replies

P: 3
Aug 9 '06 #2

Expert Mod 10K+
P: 14,534
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
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.
Aug 9 '06 #3

P: 3
I didnt think it would be :( ........but thanks for the help anyways.
Aug 11 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.