Carriage Return Line Feed in a memo field update query 2

[McLiguori]

I have a database with address fields add1, add2, add3. I have created a memo field into which I want to copy the 3 address fields. I can do it with an update query updating the memo field with [add1] & [add2], etc.

However, I need to have each address field begin on a new line in the new memo field, e.g.
[add1]
[add2]
[add3]

What syntax should I use to make the update query insert a new line command after each address field? Or is there another procedure I should be using to accomplish this?

Thanks for the help.

Ligs

 

[RickSpr]

The syntax is:
[add1] & Chr(13) & Chr(10) & [add2] & Chr(13) & Chr(10) & [add3]

Chr(13) returns a carriage return
Chr(10) returns a line feed

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[lespaul]

you need to add Chr(13) and/or Chr(10) - the ASCII codes for line return/carriage return - after each field. (i'm not sure which will work, but those are the codes you need -

http://www.asciitable.com

for more details on the codes.

leslie