Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating Columns in an Access report

Status
Not open for further replies.

KBrad28

Technical User
Feb 21, 2007
4
US
Is there a way to force a field in an Access report to look like a newspaper column? I am have created a recipe database and I want to format my ingredient field as a continous column. Is it possible to do this in Access?
 
How many columns do you want. If I understand you properly go to Page Setup ===> Click on the Columns Tab and uncheck Same as Detail. Set the report to how many columns you want and the width of each column so that they fit nicely on the page.
 
I'm trying to create 2 columns, but changing the page setup changes the whole report. I just need to force that particular field to two columns.
 
You could try remove the details from the main report and place them in a two column subreport. These generally work best if set to display across then down.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
I am very new to using access. So how would go about creating a subreport?
 
A subreport is much like a subform. It is created the same way you would create any other report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top