Null fields in criteria

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

My query references a text box on my form
[forms]![myform]![txb_EmployeeName] to filter records. If the text box is
empty (null) I want to be able to show all employee records. Presently is
the box is empty I get no records. I read an article on this along time ago
but I cannot find it. Any one know how to do this??
 
Jeff,

Enter your criteria like this...
[Forms]![myform]![txb_EmployeeName] Or
[Forms]![myform]![txb_EmployeeName] Is Null
 
Steve Schapel said:
Jeff,

Enter your criteria like this...
[Forms]![myform]![txb_EmployeeName] Or
[Forms]![myform]![txb_EmployeeName] Is Null

--
Steve Schapel, Microsoft Access MVP


Jeff said:
My query references a text box on my form
[forms]![myform]![txb_EmployeeName] to filter records. If the text box is
empty (null) I want to be able to show all employee records. Presently is
the box is empty I get no records. I read an article on this along time ago
but I cannot find it. Any one know how to do this??
Check out The Nz function
 
Back
Top