Fix Access Combo Box Drop-Down Arrow Missing in Reports
Question details
The user needs to understand why a combo box on an Access report has no drop-down arrow and learn the correct method to filter report criteria.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Viewing a database report that contains a combo box control, specifically in Print Preview mode.
- Observed behavior
- The combo box appears blank, lacks a functional drop-down arrow, and does not allow interactive data entry.
Verify whether your report is currently open in Print Preview mode or Report View, as interactive controls behave differently depending on the active view mode.
Use a Dialog Form to Collect Criteria
Instead of placing interactive controls directly on a report layout, use a dedicated dialog form to gather user input and filter the report accordingly.
Reports in Microsoft Access are designed primarily for displaying and printing results rather than interactive data entry. By design, combo boxes do not function as input controls in Print Preview.
The best practice is to create a separate form containing your combo boxes, use it to capture the user's selection, and then open the report filtered by those specific criteria.
Go to the Create tab in the Access Ribbon and select Form Design to create a blank form.
From the Design tab, select the Combo Box tool and click on the form to place it. Follow the wizard to bind it to your required lookup values.
Place a Command Button on the form. Use the Command Button Wizard to assign the Report Operations -> Open Report action.
Modify the button's embedded macro or VBA code to use the combo box value in the Where Condition argument, ensuring the report only loads the requested records.

Switch from Print Preview to Report View
If you absolutely must interact with controls directly on the report layout, you need to change the active view mode to Report View.
Looking for a Free and Lightweight Office Suite?
While Microsoft Access is a specialized database tool, much of your exported report data needs to be formatted or analyzed in a spreadsheet. WPS Office is a powerful, free alternative to Microsoft Word, Excel, and PowerPoint. You can seamlessly open exported Access data in WPS Spreadsheet for advanced charting, pivot tables, and analysis without paying expensive subscription fees.
- 1. Export Access Data: In Microsoft Access, select your report or query, navigate to the External Data tab, and export it as an Excel file.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the exported .xlsx file to continue your data formatting and analysis seamlessly.

Frequently Asked Questions
Why are combo boxes not interactive in Print Preview?
Print Preview is strictly designed to render a static view of exactly how the document will appear on printed paper. Consequently, all interactive controls like combo boxes, text boxes, and action buttons are automatically disabled.
Can I use a combo box on a report to filter the report itself?
While it is technically possible in Report View using advanced VBA programming to requery the data, it is highly discouraged. The standard database design approach is to use a separate dialog form to collect criteria before opening the report.
How do I export my Access report data to a spreadsheet?
You can right-click the target report in the Navigation Pane, select Export, and choose Excel. The resulting .xlsx file can be opened and edited seamlessly in fully compatible spreadsheet software like WPS Spreadsheet.




