I have a DVD movie database consisting of two columns--Title containing 27 letters and Location containing 5 numbers. I want to print using two columns. Under Print Setup, I have tried every combination I can, but the Title column only shows 20 letters and not the 27 letters in my Table. How can I display the 27 letters in the Title field in the Print Preview?
Thank you for your response. In Report view, I had previously resized my two columns to Best Fit. You suggested creating a new Report, but when using the Report Wizard, I find no option for setting the column width. If the column width can be set in Design view, I don't know how to do it.
I figured out how to do it! Under Reports and with my Report selected, I clicked on Design. I then double-clicked the gray box under Detail which brought up a host of options. Through trial & error, I was able to increase the width of my Title column and then increase the left margin of my Location column to correct the overlapping. Then I only had to enter Print Setup and decrease the left margin by a quarter inch to perfectly center my double column report with all my data in view.