TRIM function not working - even using the label wizard!

[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?

 

[Ken Snell MVP]

See reply to your post in m.p.a.reports newsgroup.

 

[Duane Hookom]

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"