Solved

New Lines in a memo field

Posted on 2008-06-18
6
481 Views
Last Modified: 2013-11-27
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?
0
Comment
Question by:dsoderstrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 21812952
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
 
LVL 10

Accepted Solution

by:
therealmongoose earned 250 total points
ID: 21812954
you need to use chr(13) & chr(10)

This is line feed + carriage return....
0
 
LVL 10

Expert Comment

by:therealmongoose
ID: 21813008
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:dsoderstrom
ID: 21813418
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
 

Author Closing Comment

by:dsoderstrom
ID: 31468325
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
 
LVL 10

Expert Comment

by:therealmongoose
ID: 21813902
Great - sorry should have specified that you need to use them in that order!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 64
Oracle - BLOB Extract Line 2 20
MS Access vba Print  PDF First page only 16 34
Multiple tables for a tabbed form 2 33
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question