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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rich Text Format 0
Split data in field on character return 0
Text box incomplete in GroupFooter 0
Address box with IIf Statement 7
Carriage Return 2
Report control: hide blank row when null data 2
Removing Empty Line 5
Address Label Problem 3

Back
Top