'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Microsoft Access Reports That Print with the Wrong Font Size
Question details
The user's Microsoft Access report prints with the correct font style but ignores font size changes, resulting in the wrong text size on printed documents.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Printing a filtered report triggered by an Access form button.
- Observed behavior
- Changes to the font size do not reflect on the printed report because Access requires font sizes to be set individually for each control rather than globally.
Before modifying your report design, identify exactly which text boxes or labels are printing incorrectly so you can target them in the Property Sheet.
Adjust Font Size for Individual Controls via Property Sheet
Because Microsoft Access does not apply a single report-wide font setting, you must adjust the font size for each specific control (such as text boxes and labels) in Design View.
Access handles font formatting at the control level rather than the report level. If you attempt to change the font size on a single control, other controls will remain at their default sizes unless explicitly modified.
Open your Access database, right-click the affected report in the Navigation Pane, and select 'Design View'.
Click to select the specific text box, label, or control that is printing with the wrong font size. To select multiple controls, hold down the Shift key while clicking.
Press 'F4' on your keyboard, or click the 'Property Sheet' button located in the Tools group on the Design ribbon.
In the Property Sheet, navigate to the 'Format' tab. Locate the 'Font Size' property and enter your desired numerical value (e.g., 12 or 14).
Save the report changes and switch to 'Print Preview' to verify that the new font size is applied correctly before printing.
Looking for a Lightweight and Free Office Suite?
While Microsoft Access handles complex database reporting, you can manage most of your data, lists, and printed reports easily using WPS Spreadsheet. WPS Office is a highly compatible, free alternative to Microsoft Office that makes formatting and printing documents straightforward without dealing with complex property sheets.
- 1. Export Data: Export your Microsoft Access data to an Excel file (.xlsx).
- 2. Install WPS Office: Download and install WPS Office Free on your computer.
- 3. Print with Ease: Open the exported file in WPS Spreadsheet to easily highlight, format, and print your data reports.
Frequently Asked Questions
Why doesn't the font size change apply to my entire Access report?
Microsoft Access does not have a master font size setting for an entire report. Font sizes are treated as properties of individual controls, meaning you must update the text boxes and labels independently.
How can I change the font size for all controls in Access at once?
In Design View, you can press Ctrl+A to select all controls, or hold the Shift key to click specific ones, then change the 'Font Size' in the Property Sheet. This applies the new size to your entire selection.
Why does my Access report look fine on screen but print with tiny fonts?
This usually happens if the report's display scaling or zooming is overriding the actual font size property, or if your printer driver is configured to scale the page to fit. Always verify the absolute 'Font Size' value in the control's Property Sheet.
