Using "IS NULL" for blank fields

  • Thread starter Thread starter stacie
  • Start date Start date
S

stacie

Hi

When users do not complete fields on the form, I want it to write a query
where "NULL" appears in the field on the table instead of a blank field .
Is there a way to do this?
 
You can use the Format property of the field (in the table) or text box (on
a form or report) to show the word NULL where the field is null.

Open the VBA code window, and open help there.
Look for help on Format.
It's different depending on the field type.

On a report (where no data needs to be entered), an alternative would be to
use a text box bound to an expression such as:
=IIf([SomeField] Is Null, "NULL", [SomeField])
 
Stacie

Allen's offered a way to do this.

I'm curious about why...! What will having "NULL" in the table allow you or
your users to do?

You've asked a "how" question without describing what problem this solution
would solve...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top