If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Update query to add text to form
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 . |
#3
|
|||
|
|||
Update query to add text to form
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. |
Thread Tools | |
Display Modes | |
|
|