Fix Access Rectangle Not Printing in Reports
Question details
The user needs a workaround for rectangle shapes used as borders failing to appear in printed Microsoft Access reports or Print Preview, despite being visible in Design and Report views.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Printing database reports containing rectangle shape borders.
- Observed behavior
- Rectangle objects display correctly in Design View and Report View but disappear completely in Print Preview and the final printed document.
Before modifying your report design, open the Property Sheet in Access and ensure that the rectangle's 'Visible' property is set to Yes and 'Display When' is set to Always.
Use an Image as a Rectangle Border Workaround
If native Access shapes consistently fail to print, replace the rectangle object with an image of a rectangle created in PowerPoint.
Due to rendering bugs in certain versions of Microsoft Access, native shapes like rectangles may drop out when communicating with printer drivers. Using a static image bypasses the internal shape-rendering engine.
Open Microsoft PowerPoint and insert a rectangle shape with your desired dimensions, border thickness, and transparent fill.
Right-click the newly created shape in PowerPoint and select 'Save as Picture' to export it as a PNG or JPG file.
Navigate back to Microsoft Access, right-click your report in the navigation pane, and select 'Design View'.
Select the existing native Access rectangle shape that refuses to print and press the Delete key.
Use the 'Insert Image' tool in the Access Design ribbon to place your saved rectangle picture into the report, adjusting its dimensions to encompass your data fields.

Verify Rectangle Object Properties
Check the shape's formatting settings to ensure it is not unintentionally hidden or set to transparent during printing.
Handle Your Daily Office Tasks Seamlessly with WPS Office
While WPS Office does not include a direct database management equivalent to MS Access, it provides a comprehensive, lightweight, and completely free suite for word processing, spreadsheets, and presentations. If you're looking for an alternative for your daily office tasks without the hefty subscription fees and formatting bugs, WPS Office is an excellent choice.

Frequently Asked Questions
Why do objects show in Report View but not Print Preview in Access?
This is a known rendering quirk in certain builds of Microsoft Access. Report View continuously renders data for optimized on-screen reading, while Print Preview calculates exact page margins and engages printer drivers, which sometimes causes native vector shapes to drop out of the final output.
Does the 'Display When' property affect Access report printing?
Yes. If a control or shape has its 'Display When' property set to 'Screen Only' in the Property Sheet, it will be visible while you design and view the report on your monitor, but it is explicitly instructed not to appear on the printed document.
Can I use different controls instead of a rectangle object for borders?
Yes. Instead of using a single rectangle shape, you can try using four individual Line controls to draw the top, bottom, left, and right sides of your border manually. Line controls will sometimes successfully bypass the printing bug that affects complete rectangle shapes.




