murray83
Games Collector
- Local time
- Today, 03:09
- Joined
- Mar 31, 2017
- Messages
- 728
so i have 3 text boxes on my report which are filled in by hand, but on occasion they arent needed and to save confusion with paperwork being reported as incorrect ( as these 3 sections have been missed ) so i have tried the following in the report load but nothing changes
so i though that prehaps the text box wasnt being updated or couldnt be read, as the details for the report are pulled into via a query, so then i added another text box and made the new boxes control source Text444 and changed my code as so, and still no dice so any help would be grand, cheers
Code:
Private Sub Report_Load()
If Me.Text444.Value = "ALCOHOL FREE" Then
Me.txtJDAComplete.Visible = False
Me.txtDMSProcessed.Visible = False
Me.txtEMCSProcessed.Visible = False
Else
Me.txtJDAComplete.Visible = True
Me.txtDMSProcessed.Visible = True
Me.txtEMCSProcessed.Visible = True
End If
End Sub
so i though that prehaps the text box wasnt being updated or couldnt be read, as the details for the report are pulled into via a query, so then i added another text box and made the new boxes control source Text444 and changed my code as so, and still no dice so any help would be grand, cheers
Code:
Private Sub Report_Load()
If Me.txtARC.Value = "ALCOHOL FREE" Then
Me.txtJDAComplete.Visible = False
Me.txtDMSProcessed.Visible = False
Me.txtEMCSProcessed.Visible = False
Else
Me.txtJDAComplete.Visible = True
Me.txtDMSProcessed.Visible = True
Me.txtEMCSProcessed.Visible = True
End If
End Sub