No data displayed if Memo field is blank

[drrep]

Hi,

I have created a keyword search form. In this, I allow users to enter keywords and dates to bring up data in a report

Problem is that say if the user enters nothing as a keyword for a Memo field, eventhough I added the following in that memo field's criteria:

Like "*" & [Forms]![Keyword Search]![Text24] & "*"

It doesn't pick ANY DATA at all up when Text24, text field located in the keyword search form used to look up keywords in the Memo field, is left empty.

I know there is data in the table I am referring to and that if Text24 is left blank, it should pick up everything since nothing was narrowed down to a specific criteria

Help anyone??

Thanks in advance

 

[gny]

Check that the value of Text24 isn't NULL instead of "".

 

[drrep]

Where would I test that? I don't see how that will help my query selection window...