By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Error using Trim

P: 5
Hi

I am using trim in Access 2007 and it is returning Error
Expand|Select|Wrap|Line Numbers
  1. =Trim([SHIP TO CITY] & ", " & [SHIP TO STATE] & "  " & [SHIP TO ZIP])
This works in 2003 but not in Access 2007.

Do you why
Jan 14 '10 #1

✓ answered by ADezii

Try a variation of the above, and see if it works:
Expand|Select|Wrap|Line Numbers
  1. =LTrim([SHIP TO CITY]) & ", " & [SHIP TO STATE] & " " & RTrim([SHIP TO ZIP])

Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,599
Try a variation of the above, and see if it works:
Expand|Select|Wrap|Line Numbers
  1. =LTrim([SHIP TO CITY]) & ", " & [SHIP TO STATE] & " " & RTrim([SHIP TO ZIP])
Jan 14 '10 #2

P: 5
Thanks ADezii,

It worked.
Jan 14 '10 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.
Jan 14 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.