Null struggles

[kwtmd]

What exists in a "field" in a table when no records have yet been added? When I debug.print the field, it results in "null". However, any VBA line that references this as "null" does not seem to work. I am trying to default a field only when the first record is added. After the first record is added, the default value changes. Any suggestions are welcome. thanks. Kwt

 

[WayneRyan]

kwt,

You are right, before (and even during) the time a record is created, a
typical field has a value of NULL.

However, depending on how you reference it in VBA code, it may not be
NULL.

How are you referencing it in VBA code?

IsNull(SomeField) ...

If SomeField = NULL ...

If SomeField = "" ...

These are all kinda sorta ways to reference a "NULL" value, but I need more
specifics here.

Wayne