Results 1 to 4 of 4
  1. #1
    AlexTheGr8 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Location
    Ontario
    Posts
    11

    Export a really long report? Running out of space!

    Hi All,

    The staff using my database want to be able to get one really long report with tombstone paragraphs in it. In total it will be around 10 pages. I was planning on copying and pasting all their paragraphs into the report as text boxes, and then putting in a query that also provides insight on the data in the database. Then they wanted this to be shown in Word.

    The snag is that I'm running out of text box space in the report design phase. I can't fit all of the stand alone text into the report.

    Is there a better way to do this?

    Thanks!


    A

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    These paragraphs are not data in table, just static text in textbox ControlSource? Are you using CanGrow set to Yes?

    If still an issue, options:

    1. paragraphs in table and table in report RecordSource

    2. subreports

    3. Access/Word merge

    4. multiple reports that are printed in sequence

    If you want to provide db for analysis, follow instructions at bottom of my post.

    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    AlexTheGr8 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2019
    Location
    Ontario
    Posts
    11
    Hi June7,

    You solved my issue, thank you.
    Yes, it was static text in a textbox. Unfortunately CanGrow doesn't work on that type of item in Access.

    What I did was option 1 that you mention. I saved the long paragraphs into a table as "Rich Text" and then imported them into the report through a query. It auto-resizes in Word when I export.

    Thank you!
    A

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    CanGrow works for UNBOUND control in Group or Detail or Report section - not in Page section.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-25-2018, 09:53 AM
  2. Replies: 3
    Last Post: 04-27-2016, 12:21 PM
  3. Long running query in Access 2010
    By Karla in forum Queries
    Replies: 0
    Last Post: 11-24-2014, 01:29 PM
  4. White Space on Report
    By vansicklej in forum Reports
    Replies: 4
    Last Post: 07-31-2012, 12:00 PM
  5. Export to RTF is creating white space at end of page
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:24 PM

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