How to Remove Extra Spaces in Access Reports


Remove extra spaces from your Access reports with the CanShrink property. This property ensures the extraneous spaces are eliminated prior to printing. Access this property by viewing the report in design view. While in design view, make sure your objects are in appropriate positions on your report. If necessary, move the report objects closer if too much space appears between columns or rows. After making this change, right-click on the report object and change the CanShrink property to remove extra spaces.

  • Open Access 2010 and select a database. Click the "File" tab and click "Open." Browse your files and locate the database. Double click the database. The database opens.

  • Locate your report on the Navigation Pane. Right-click the report and select "Design View." Review the orientation of the report objects. If some objects are too far away from each other, select an object or objects and the text boxes. Select both by holding the "Control" key. Carefully drag them to a location more appropriate for the report. Review the changes, clicking the "View" button on the "Home" tab. Before continuing to the next task, make sure the spacing is appropriate for each report object.

  • Right-click the report text box. Select "Properties." Change the "CanShrink" property to "Yes." Click the "Home" tab and change your view to "Datasheet View." Review the changes.

Related Searches


Promoted By Zergnet



You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!