Fields on a report

Topic

New Reply

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?

Thanks

Reply | Quote

Replies

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.

Reply | Quote