I have a MS access report that has multiple data fields. I know how to get the box to not show if there is no data by using an event and the code visible.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Len(Nz(Me.YourField)) > 0 Then
Me.Label1.Visible = True
Else
Me.Label1.Visible = False
End If
End Sub
My issue i have 8 text boxes that represent different columns in my table. If they are blank i want to suppress them and then move up the lower boxes if they have data. Basically shrink the whitepace. Is there a way or will i have to code it and move up boxes that way? Thanks.
- Me.Control.Left = #
- Me.Control.Top = #