Forum Discussion
AmyLynnFall
Jan 09, 2021Copper Contributor
default field
I'm creating a table in access and want the NickName field's default value to equal FirstName. How do I do this?
1 Reply
- George_HepworthSilver Contributor
You can do this in the form where you enter your data.
In the text box control for NickName, put this in the DefaultValue property:
=[FirstName]
This will ONLY work, of course, if you have previously put some value in the FirstName field.