Forum Discussion

AmyLynnFall's avatar
AmyLynnFall
Copper Contributor
Jan 09, 2021

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_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    AmyLynnFall 

    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.