Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Fields on a report

    I have a field on a report that when it growns is pushing a single line to the top of the next page. Is there a way to force it to put it all on the one page or force the entire content to go to the next page?


  2. #2
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Seattle, WA., USA
    Thanked 12 Times in 12 Posts
    Hi Richard,

    In Access 2003*, you can experiment with View | Sorting and Grouping
    Select the field of interest as the Field/Expression and try changing the Keep Together property to Whole Group. That might give you the effect you desire.

    You might also try experimenting with the Section property. For example, with the Detail Section selected, if you look on the Format tab of the Properties sheet, you should see Keep Together property. Try setting it to Yes, to see if this produces the desired result.

    * Sorry, I'm not using the newer versions of MS Access on a daily basis, so I cannot tell you how to find the equivalent functionality in A2007, A2010 or A2013. It is there, you just might have to play the Where's Waldo game to find it.
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

Posting Permissions

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