** 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...
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...