Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append Text (2000)

    I have a memo field in a table - to be used add comments related to a record. Is there a way to quickly add or "append" text into this field? I have a button on a form that creates a letter in Word. Can this same button action send some text into the memo field ("Letter sent on Feb 2 by David"). It would have to APPEND text, not overwrite existing text already in the memo field.

    THANK YOU! I've been looking all over the place for the command or action that can do this, but I've found nothing so far.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append Text (2000)

    Not sure in what situation or event you need to do this but something like this should work:

    Me.MemoControl = Me.MemoControl & " Text you want here"

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append Text (2000)

    THANK YOU! This works beautifully. (You can tell I don't know VBA - I am amazed everytime it works.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •