Update query to add text to form

[Nick]

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

Thank

Nic

 

[Tony C]

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.

 

[fredg]

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.";