RacerGirl117
Technical User
I have a report that contains a memo field. Some of the records in the report need to be eliminated based on whether or not the field contains the word "transfer". The word could be located anywhere in the field. I've attempted to do this via the query, but it's not working correctly (eliminating records it shouldn't). I'd like to do this in code, but I don't even know if it's possible.
So my question is... is it possible to eliminate records based on contents in a memo field? If so, how would I do that with VBA?
I've tried
If Comments = "*transfer*" Then
Detail.Visible = False
Else
Detail.Visible = True
End If
but I get an error message sayint it can't find the field Comments.
Thanks in advance, Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA
So my question is... is it possible to eliminate records based on contents in a memo field? If so, how would I do that with VBA?
I've tried
If Comments = "*transfer*" Then
Detail.Visible = False
Else
Detail.Visible = True
End If
but I get an error message sayint it can't find the field Comments.
Thanks in advance, Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA