Re: Update query to add text to form
From: fredg (fgutkind_at_example.invalid)
Date: 06/04/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Email In Access 97 Help please"
- Previous message: M Skabialka: "Error 2427 You entered an expression that has no value"
- In reply to: Nick: "Update query to add text to form"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 04 Jun 2004 14:02:19 GMT
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.
- Next message: anonymous_at_discussions.microsoft.com: "Re: Email In Access 97 Help please"
- Previous message: M Skabialka: "Error 2427 You entered an expression that has no value"
- In reply to: Nick: "Update query to add text to form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
