Results 1 to 5 of 5
  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659

    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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    In my report the content breaks and continues to next page. You want to force all onto next page?
    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
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    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.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Did nothing special. Textbox in Detail 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.

  5. #5
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    removed the text box and placed it again. now its doing as you said. O.o

    thanks for the help!

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

Similar Threads

  1. Replies: 1
    Last Post: 06-27-2014, 05:10 PM
  2. Replies: 8
    Last Post: 08-09-2013, 04:09 PM
  3. Replies: 3
    Last Post: 10-17-2011, 02:38 PM
  4. Report prints garbage after page 3
    By chrysalid in forum Reports
    Replies: 2
    Last Post: 10-03-2011, 11:05 AM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08: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
  •  
Other Forums: Microsoft Office Forums