I've got a text field in a form whose default value is equal to an input field of a form, that automatically opens just to set this value once for all. It works perfectly, but I receive an error when the input field is left empty. Has this something to do with Nz? What is the correct sintax in text field to avoid #name? when addressing to a null input field?Thanks again, you're very helpful to my work!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I'm so active ,you're so helpful...Nz
- Thread starter brucomela
- Start date
If you have a null value, and want to bypass the #Name? or #Error message, create an IIf statement in the control source.
IIf [FieldName] is Not Null, [FieldName],"n/a"
In this statement you are saying if the [fieldname] is not null, display the [fieldname]. If the [fieldname] is null, it will display "n/a" instead.
Hope this helps!
-Angela
IIf [FieldName] is Not Null, [FieldName],"n/a"
In this statement you are saying if the [fieldname] is not null, display the [fieldname]. If the [fieldname] is null, it will display "n/a" instead.
Hope this helps!
-Angela
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question