Others

Fix Access Combo Box Drop-Down Arrow Missing in Reports

Steven ParkerSteven Parker Oct 16, 2026 868 views

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.

Fix Access Combo Box Drop-Down Arrow Missing in Reports
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new dialog form

Go to the Create tab in the Access Ribbon and select Form Design to create a blank form.

2
Add a combo box control

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.

3
Add a command button

Place a Command Button on the form. Use the Command Button Wizard to assign the Report Operations -> Open Report action.

4
Apply the filter criteria

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.

Use a Dialog Form to Collect Criteria
Best Practice: Using a form to drive report parameters keeps your data presentation clean and ensures your database interface remains robust and user-friendly.
Free Microsoft Office alternative

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. 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. 2. Open with WPS Spreadsheet: Launch WPS Office and open the exported .xlsx file to continue your data formatting and analysis seamlessly.
Free and lightweight office suite for Windows, Mac, and LinuxFully compatible with Microsoft Excel (.xlsx) formats for your exported Access report dataFamiliar, tabbed user interface ensures a seamless migration and zero learning curveBuilt-in PDF editing, formatting, and document management tools
QA img-9

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.