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

[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

 

[John W. Vinson]

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

Add a criterion

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

to the other criteria referencing said textbox.

 

[Jeanette Cunningham]

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