C
ccw
MSAccess 2003
My simple form has several fields arranged vertically in the detail section.
Some of the fields may have null or zero-length string values.
I have the Can Shrink property of each control set to "Yes".
In the code for the Detail_Format event, I have the following type of logic,
replicated for each control:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Controls("Description").Visible = True
If Me.Controls("Background").Text = "" Then
Me.Controls("Background").Visible = False
End If
'Same thing for next control....
'Same thing for next control....
End Sub
In the debugger I can see that the Visible property is set to Flase when the
text value of the control is "".
WHAT I DO NOT GET IS why the print preview still shows vertical space where
there is a shrinkable invisible control.
Thanks in advance. -CCW
My simple form has several fields arranged vertically in the detail section.
Some of the fields may have null or zero-length string values.
I have the Can Shrink property of each control set to "Yes".
In the code for the Detail_Format event, I have the following type of logic,
replicated for each control:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Controls("Description").Visible = True
If Me.Controls("Background").Text = "" Then
Me.Controls("Background").Visible = False
End If
'Same thing for next control....
'Same thing for next control....
End Sub
In the debugger I can see that the Visible property is set to Flase when the
text value of the control is "".
WHAT I DO NOT GET IS why the print preview still shows vertical space where
there is a shrinkable invisible control.
Thanks in advance. -CCW