Error using Trim

[rafnavsun]

Hi

I am using trim in Access 2007 and it is returning Error

=Trim([SHIP TO CITY] & ", " & [SHIP TO STATE] & "  " & [SHIP TO ZIP])

This works in 2003 but not in Access 2007.

Do you why

[ADezii]

Try a variation of the above, and see if it works:

=LTrim([SHIP TO CITY]) & ", " & [SHIP TO STATE] & " " & RTrim([SHIP TO ZIP])

[rafnavsun]

Thanks ADezii,

It worked.

[NeoPa]

I'm pleased you got an answer, but next time please save us all some trouble and post the error message when reporting a problem. It's a very rare case that a question makes sense reporting an error without the message. This is not one of those.