Update query to add text to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...
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.
 
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
Click to expand...
No macros needed. Just do it in the update query.

Update YourTable Set YourTable.MemoField = MemoField & chr(13) &
chr(10) & "Your new text.";
 
Back
Top