dsoderstrom
asked on
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?
mbizup
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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....
ASKER
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.
ASKER
I had tried this previously but had Chr(10) before Chr(13) . When I put them in the right order it works. Thank You.
Great - sorry should have specified that you need to use them in that order!