The database engine does not recognize either the field <name> in a validation expression, or the default value in the table <name>.
Boris AlvarezOP
@Reply 3 years ago
Hi I keep getting this message when trying to format the 'ullName field using the expression
FullName: FirstName & LastName
Thank you
David Burns
@Reply 3 years ago
Hi, I have something similar but with a space so I get John Smith rather than JohnSmith
Try FullName: [FirstName] & " " & [LastName]
David Burns
@Reply 3 years ago
Also meant to say to double-check the field names in your table. Make sure you have FirstName and LastName, not First Name or Last Name (with spaces). It's easily done.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 9.
