That should work - it does on my test form.
@;"Enter Customer Name"
What type of data is it bound to ?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Text box is unbound
Something else must be wrong. @;"enter value" works on 4 of the unbound text boxes but not on one of the others.
Maybe the underlying data for that field is not Null but a Zero Length String (or "") as that will fail the Null test.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓