I dont know how to ignore null fields on a search form...

[joeconway]

my problem is basically as the title suggests. I havea search form with multiple text boxes in, when I run the query i need it to check to see if the text box is empty and if not add it to the filtering criteria.

Any help would be much appreciated because I'm stumped

 

[Remou]

This:

[tt]If Trim(Me.[Name of textbox] & "")="" Then
'This text box is either spaces, a zero length string, or null[/tt]


Is quite a common way to check

 

[KornGeek]

alternatively:

If Nz(Me.[Name of textbox], "") = "" Then
'Does the same as above, but treats entries of all spaces as distinct and legitimate values