Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2015
    Posts
    2

    Unanswered: form letter within access

    I'm trying to use access to create individual client letters, where I can enter all the discrete data into my form, and then have a customized letter with that client's info. I assume this would be a type of report, right?
    Also...I need to be able to cut and paste from the individualized letter into another application (i.e. email)
    I'm a bit of a newbie, so forgive me, but here are my problems:
    - I can't figure out how to create a form/report where you have data cells inside a separate text box
    - When I almost get this to work, I can't copy and paste the entire text

    Any help/templates?!

    Thanks!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Have you tried a textbox control source like:

    ="Fixed text here " & [FieldNameHere] & " more fixed text here"
    Paul

  3. #3
    Join Date
    Mar 2015
    Posts
    2
    getting close! that's helpful. now my problem is that Access doesn't realize my fields are text strings (even though they are labeled that way) so it won't let me insert them into another text string.
    excel has a formula TEXT([field]) that labels the field, can't find that in Access..

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Sorry, I'm out of the country. What exactly are you trying to do? If you're working in code, couldn't you use the same method as the control source?
    Paul

Posting Permissions

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