Concentrate First Name & Surname Fields in form?

[clarerome14]

Hi,

I am currently using Access 2007, where I used to be able to concentrate First Name and Surname Fields by simply using:

= [First Name] &" "& [Surname]

However I have downloaded Access Run Time 2010 on the other employees computers so they will be able to access the Database, however since i have done this the First Name and Surname do not appear, it simply shows:

#Name?

I am guessing this is because it is a newer version, however even when I open the Database with Access 2007 it still does not work, even if I delete it and add it again.

Can anyone please help, it is sending me insane!

 

[pr2-eugin]

#Name Error occurs mostly when Access is unable to find the specific Control/Field names.. Which property have you set using the above statement?

 

[ions]

Also make sure you don't have a circular Reference. Make sure the text box name is not First Name OR Surname.