Printing Problems

Fix Access Rectangle Not Printing in Reports

Camila MilosovichCamila Milosovich Oct 22, 2026 869 views

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.

Fix Access Rectangle Not Printing in Reports
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 you start

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.

Solution 1Recommended

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.

1
Create the shape in PowerPoint

Open Microsoft PowerPoint and insert a rectangle shape with your desired dimensions, border thickness, and transparent fill.

2
Save as a picture

Right-click the newly created shape in PowerPoint and select 'Save as Picture' to export it as a PNG or JPG file.

3
Open Access Report Design View

Navigate back to Microsoft Access, right-click your report in the navigation pane, and select 'Design View'.

4
Remove the faulty shape

Select the existing native Access rectangle shape that refuses to print and press the Delete key.

5
Insert the image border

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.

Use an Image as a Rectangle Border Workaround
Sizing Adjustments: You may need to iterate a few times between PowerPoint and Access to get the image dimensions exactly right for your specific report margins.
Free Microsoft Office alternative

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.

High compatibility with Microsoft Word, Excel, and PowerPoint formats.Create complex reports and data tables easily in WPS Spreadsheet without layout printing errors.Completely free, lightweight, and fast to launch on Windows, Mac, and Linux.Familiar tabbed user interface, ensuring zero learning curve for easy migration.
microsoft office alternative - wps office

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.