Access reports - Keep header and first record together in one column (i.e. prevent them from separating if a heading lands at the end of a column)
Posted on 2014-03-27
I'm trying to make a phone list with an MS Access report. The list is grouped by departments, with a heading for each group showing the department name. In order to make the list fit on one 8.5 x 11 page, I've got it split into 4 columns.
My problem: I want the heading and first record to be kept together in one column (i.e. prevent them from separating if a heading lands at the end of a column), but I can't find a way to do that. As such, one of the department headings starts at the very bottom of a column, and the records start in the next column. There's a group setting to "Keep header and first record together on one page", but not for columns. Anyone know a way to do this?