AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.

Multiple records per page for Access 2007

I'm using Access 2007 and I want multiple records per page. I have too many columns for the Tabular format, even in Landscape orientation, so I chose Justified format. But Justified only allows you to have one record per page. What do?

Fairly simple technique. Arrange the textboxes in two lines in the Detail section. Create a line control just below them to define each record. Then arrange the labels in two lines in page header section. If you want, shift the second line of labels and textboxes so they aren't exactly below the previous line. Do any fields have very long strings of text? I think will have to set the CanGrow property of first line of textboxes to No or they might expand over the second line.