displaying NULL if no data is present

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello
I'm using a form to display the contents of a table and if there is
no data present in a particular field, it should display NULL or NIL in the
corresponding textbox. How can this be done with a few lines of code.

Thanks for any help

regards
talktobatchu
 
If you make the field an dunbound field, you can use the Nz function...


= Nz([SomeFieldNAme],"Null")
 
hello
I'm using a form to display the contents of a table and if there is
no data present in a particular field, it should display NULL or NIL in the
corresponding textbox. How can this be done with a few lines of code.
Click to expand...
You can do it with no code at all, if it's a numeric field: set the
textbox's Format property using the "four value format", for positive,
negative, zero and NULL entries respectively:

#;-#;"0";"NULL"


John W. Vinson[MVP]
 
Back
Top