name displays errors

  • Thread starter Thread starter Rotata
  • Start date Start date
R

Rotata

My organization is moving to Office 2007 in a few weeks.

Being the closest thing to an Access expert that we have, I got an early
install to help work out the kinks. I am having numerous problems preparing
for the transition.

I'm not a programmer. I do not have administrative rights on my own machine.
I cannot change permissions.

Today’s trouble:
I have a LOT of forms in my Access 2003 database. On the ones that deal with
personnel, I create a big, bold header of Last, First. That way, no matter
what tab one is on, you can confirm you are working with the correct employee.
The formulae I have always used to display the name is = ([last] &â€, “&
[first])
This no longer works. I get a “name†error.
What must I do to correct this problem?
 
Rotata,

Just something to try, place a space between the ampersand and double quote:

([last] & ", " & [first]) Yours is:
([last] &", "& [first])

You really shouldn't have any big issues if you open your existing database
files in Access 2007. I even develop .mdb files in A2007.

God Bless,

Mark A. Sam
 
Back
Top