New to Reports

  • Thread starter Thread starter Derek Martin
  • Start date Start date
D

Derek Martin

Hi list, I have a report that I am generating using the Label Wizard. The
field I need to put into it is an address field that contains:
Address, City, State, ZIP

This is a single field, whos elements are seperated by chr(10). Is there a
way to have Access format that field to insert the line break on chr(10)?

Thank you,

Derek
 
Never mind! Found what I needed on thread from 11/11/04 regarding the exact
same issue! Thank you Duane!!!

Derek
 
Hi list, I have a report that I am generating using the Label Wizard. The
field I need to put into it is an address field that contains:
Address, City, State, ZIP

This is a single field, whos elements are seperated by chr(10). Is there a
way to have Access format that field to insert the line break on chr(10)?

Thank you,

Derek
Click to expand...

In Access you must use chr(13) & chr(10) in that order.

=[Address] & chr(13) & chr(10) & [City] & ", " & [State] & " " & [Zip]
 
Back
Top