Hi folks.
I have a field in a report which contains combined values i.e. =[D Med 1] & " " & [D Med 1 Dose] & "mg" & " " & [D Med 1 Freq]. I'm trying to set the field visible property to false if the field has no specific data in it, ie. only contains "mg" without the medication name or dose or frequency. The following code whilst not throwing up errors, isn't working:-
Private Sub Report_Load()
If Me.Discharge_Meds_10 Like "mg*" Then
Me.Discharge_Meds_10.Visible = False
Else: Me.Discharge_Meds_10.Visible = True
End If
End Sub
Can anyone offer any help on where i'm going wrong?
thanks in advance.