Results 1 to 5 of 5
  1. #1
    sstrause424 is offline Novice
    Windows 11 Office 365
    Join Date
    Feb 2024
    Posts
    2

    Access Reports = Boilerplate text

    Does Access support any type of free text or boiler plate text in a report? Specific case is a small non profit and end of the year giving statements - all the gift info is stored in Access database and up to now we have been doing Word mail merges to generate the receipts.



    - The organization diretort rights a paragraph long "Thank you fir your continued support . . ." which talks about what the organization accomplished the past year. This lasy year the paragraph was just over 150 words.
    We many just have to continue using mail merges for this because I'm not suire the standard text tools will support - please let me know if I am missing something.

    Thanks

    Sheldon

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,772
    I think it would be pretty much the same as in mailmerge.
    You would need if statements to know what to show?

    You could have it all stored in a memo field and then do a DlookUp() ?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    sstrause424 is offline Novice
    Windows 11 Office 365
    Join Date
    Feb 2024
    Posts
    2
    Here I'm using the word statements as another term for receipts, as in the whole report is a statement of account.
    I'll look at what you mention but so far I'm inclined to stay with the mail merge. I was hoping to use the Access report somewhat I have used Crystal reports or Oracle Reports in the past, but they both supported some time of boiler plate or unbound text
    paragraphs.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,495
    You can have a textbox with a control source of:

    ="Thank you fir your continued support . . ."

    If you run into length issues you can break it into separate textboxes. I'd use a table field as already mentioned though.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,354
    you can use a longtext field to store your boilerplate text and if you need to include other data such as the donor name or value of gift, use a placeholder and the replace function when outputting. e.g.

    "Dear [donorname],

    Thank you for your gift of [giftvalue]"


    and in the query for your report

    fulltext: replace(replace([boilerplateText],"[donorname]",[donor]),"[GiftValue]",[Gift])

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Rich Text in Reports
    By rkebab in forum Reports
    Replies: 2
    Last Post: 03-27-2023, 09:22 AM
  2. Replies: 4
    Last Post: 03-20-2019, 12:08 PM
  3. Editable text box in reports
    By ScottySchultz in forum Access
    Replies: 2
    Last Post: 02-06-2018, 11:11 AM
  4. Access 2013 truncating Long Text fields in Reports
    By TundraMonkey in forum Reports
    Replies: 13
    Last Post: 04-18-2017, 08:11 PM
  5. Unbound Text box in reports
    By Overdive in forum Reports
    Replies: 1
    Last Post: 02-17-2010, 09:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums