Update query to add text to form

Hi,

I have an update query that adds text to a memo field. problem is the txt is added directly after the last character. How do it get it to add the text to a new line in the text box? I have tried using various combinations of macros.

Thanks

Nick

Do you call the query from a command button or vba code?
If you do then you could edit the code to add Chr(13) to
the end of the field before running the query.

Tony C


-----Original Message-----
Hi,

I have an update query that adds text to a memo field.
problem is the txt is added directly after the last
character. How do it get it to add the text to a new line
in the text box? I have tried using various combinations
of macros.

Thanks

Nick


.

On Thu, 3 Jun 2004 20:51:02 -0700, Nick wrote:

Hi,

I have an update query that adds text to a memo field. problem is the txt is added directly after the last character. How do it get it to add the text to a new line in the text box? I have tried using various combinations of macros.

Thanks

Nick
No macros needed. Just do it in the update query.

Update YourTable Set YourTable.MemoField = MemoField & chr(13) &
chr(10) & "Your new text.";
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.