Results 1 to 5 of 5

Report with Memo field only prints on 1 page

  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Feeding Doritos to a Tree
    Posts
    554

    Unhappy Report with Memo field only prints on 1 page


    Using Access 2007.

    I have a report with a memo field that contains notes for the record. Normally the note field is under 400 characters and life is great. but sometimes it has more information(in this case 1700'ish characters). How can I get this information to be printed on a 2nd page? I have tried the allow grow option for properties on the detail and control, this does not print the content of the notes onto the 2nd page.

    Thank you for your time
    Patience serves as a protection against wrongs as clothes do against cold.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    42,287
    In my report the content breaks and continues to next page. You want to force all onto next page?
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Feeding Doritos to a Tree
    Posts
    554
    I want it to break and continue onto the next page. How did you get it to break? Currently it fills unto the control cannot grow anymore. then the rest of the text looks to truncate. The truncated text does not appear on the next page.
    Patience serves as a protection against wrongs as clothes do against cold.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    42,287
    Did nothing special. Textbox in Detail section.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Feeding Doritos to a Tree
    Posts
    554
    removed the text box and placed it again. now its doing as you said. O.o

    thanks for the help!
    Patience serves as a protection against wrongs as clothes do against cold.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-27-2014, 04:10 PM
  2. Replies: 8
    Last Post: 08-09-2013, 03:09 PM
  3. Replies: 3
    Last Post: 10-17-2011, 01:38 PM
  4. Report prints garbage after page 3
    By chrysalid in forum Reports
    Replies: 2
    Last Post: 10-03-2011, 10:05 AM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 07:51 PM

Tags for this Thread

Posting Permissions

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