Format Address

[turks67 via AccessMonster.com]

How can I format this ([account name] & ", " & [customer street address] & ",
" & [city] & " , " & [state] & " , " & [zip code]) in a query to show on a
Form or Report to look like this below.

Account Name
Customer Streer Address
City state Zip Code

 

[Allen Browne]

Try an expression like this:
=[account name] + Chr(13) + Chr(10) & [customer street address] + Chr(13) +
Chr(10) & [city] & " " & [state] & " " & [zip code]

 

[turks67 via AccessMonster.com]

Thank you.

Try an expression like this:
=[account name] + Chr(13) + Chr(10) & [customer street address] + Chr(13) +
Chr(10) & [city] & " " & [state] & " " & [zip code]

How can I format this ([account name] & ", " & [customer street address]
& ",

[quoted text clipped - 4 lines]

Customer Streer Address
City state Zip Code