Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to create a new line when setting new value to Memo box

Status
Not open for further replies.

JMPUK

Technical User
Feb 14, 2004
15
GB
** CHALLENGE:
I am trying to create a new line by assigning some value to a MEMO field from a module but haven't quite masterd this.
Here below what I am trying to do:

Forms!Welcome!Memo = Eval("[Forms]![Welcome]![Memo] & ""line 1:abcd line 2:efg""")


** RESULT WITH ABOVE STATEMENT
Basically here the result would be for the Memo field:
...
line 1:abcd line 2:efg

** RESULT DESIRED
But what I would like to create is as below:
...
line 1:abcd
line 2:efg

** WHAT I'VE TRIED TO DO:
I have tried to use chr$(XXX) but this does not seem to work, there must be a constant which would instruct Access to go to the next line...


As anyone got any idea?
Thanks in advance...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top