If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms - Option for user to leave some text boxes as blank.
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 -- fa |
#2
|
|||
|
|||
Forms - Option for user to leave some text boxes as blank.
On Tue, 27 Apr 2010 11:58:02 -0700, fa wrote:
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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Forms - Option for user to leave some text boxes as blank.
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 "fa" wrote in message ... 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 -- fa |
Thread Tools | |
Display Modes | |
|
|