Using "IS NULL" for blank fields

[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?

 

[Allen Browne]

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])

 

[Jeff Boyce]

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