TRIM function not working - even using the label wizard!

  • Thread starter Thread starter HonSecGA
  • Start date Start date
H

HonSecGA

I have a database which was originally created in the previous version of
Access. Ever since I upgraded to 2007 my mailing labels do not work.

I tried creating new ones using the wizard and it comes up with the same
problem.
The problem is:
It does not recognise the trim function in the expression - when I click to
preview the report it asks me for TRIM - as if it is a missing field name!
I know the expression is correct because it is the one that the program
creates itself when using the wizard:
e.g.
=Trim([county] & [postcode])

I can't see how to fix this as it appears to be exactly as it is supposed to
be.
Any ideas why this is happening?
 
You shouldn't even need to use Trim(). Try just take it out:
=[Country] & " " & [PostCode]
Your issue might be one of references. Search Google on "access references"
 
Back
Top