Text box help

[BruceM]

Ah, I see. The If...Then would be necessary only if DefaultValue is dropped
from the code. DefaultValue is redundant with If Me.NewRecord, or If...Then
is redundant with DefaultValue. But would DefaultValue apply any time the
field is blank, whether or not it is a new record, or only with a new record?
I think I remember something from earlier in the thread that the field in
question could be blank.

 

[Ken Snell [MVP]]

An ACCESS form will insert the value from the Default Value property only at
the time of creating the new record. If you later delete the value from that
field, it will remain empty until you put something back into it
deliberately.

 

[BruceM]

Thanks. I realize now that I didn't quite understand default value.

 

[G.I.O.]

Ken:

This is it! This will work for me just fine and dandy.

Thank you!
George