Forms - Option for user to leave some text boxes as blank.

  • Thread starter Thread starter fa
  • Start date Start date
F

fa

Hello. I am using MS Access 2007. I have a form that is linked to a query. I
am trying to give the user the option of leaving some text boxes blank if
they do not have the infomation. What formula do i use in the query?

Thanks
 
Hello. I am using MS Access 2007. I have a form that is linked to a query. I
am trying to give the user the option of leaving some text boxes blank if
they do not have the infomation. What formula do i use in the query?

Thanks
Click to expand...

Add a criterion

OR [Forms]![nameofform]![nameofcontrol] IS NULL

to the other criteria referencing said textbox.
 
The option to leave some text boxes blank is the default behavior of a form.
It doesn't require any formula in the query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top