Hi there,
I have been trying to figure out how to make a textbox if it is null to be invisible on a report.
My experience in programming is somewhat limited so any help is greatly appreciated. This is one of the ways I have tried but I maybe on the wrong track.
I selected the detail section on the report, under the Event tab, On Format option then selected [Event Procedure] and then clicked on the ellipses.
Tbl_Receipt_Description is the name of the text box.
*******************************************
If Me.Tbl_Receipt_Description = “ ” then
Me.Tbl_Receipt_Description.Visible = False
Else
Me.Tbl_Receipt_Description.Visible = True
End If
*******************************************
[FONT="]Thanking anyone who is able to help with this it is greatly appreciated.[/FONT]
I have been trying to figure out how to make a textbox if it is null to be invisible on a report.
My experience in programming is somewhat limited so any help is greatly appreciated. This is one of the ways I have tried but I maybe on the wrong track.
I selected the detail section on the report, under the Event tab, On Format option then selected [Event Procedure] and then clicked on the ellipses.
Tbl_Receipt_Description is the name of the text box.
*******************************************
If Me.Tbl_Receipt_Description = “ ” then
Me.Tbl_Receipt_Description.Visible = False
Else
Me.Tbl_Receipt_Description.Visible = True
End If
*******************************************
[FONT="]Thanking anyone who is able to help with this it is greatly appreciated.[/FONT]