New Lines in a memo field

I'm trying to use a query to write addresses to a memo field in an Access Table.  I want each line of the address to be displayed as a new line in the memo field.  I though I could do this by adding "& chr(13) &" between the address fields but it doesn't work.  When displaying the memo field in a form the address fields are not on seperate lines but rather I see a small square where the new line break should be.  Is there another way to do this?
dsoderstromAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
therealmongooseConnect With a Mentor Commented:
you need to use chr(13) & chr(10)

This is line feed + carriage return....
0
 
mbizupCommented:
Not an answer to your question, but you're generally better off storing the components of the address (addr1, addr2, city, state, etc ) as seperate fields.   It facilitates displaying the lines as you need to, and is easier to maintain.
0
 
therealmongooseCommented:
also if you populate the field through a form rather than directly into the table, the memo text field of the form as an Enter key property, which can be set to  "New Line in Field" - there fore accepting returns in your data. PS agree with mbizup - address data better stored in separate fields....
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
dsoderstromAuthor Commented:
I've also tried using chr(13) and chr(10).  Then I see two small squares instead of one and still don't get a new line.
0
 
dsoderstromAuthor Commented:
I had tried this previously but had Chr(10) before Chr(13) .  When I put them in the right order it works.  Thank You.
0
 
therealmongooseCommented:
Great - sorry should have specified that you need to use them in that order!
0
All Courses

From novice to tech pro — start learning today.