Others

How to Add Explanations to Microsoft Access Query Prompts

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to display clear explanations and lengthy instructions for parameter prompts in a Microsoft Access query to ensure correct data entry.

Product: Microsoft Access
Device & OS: not provided
Scenario: Setting up a query that requires user input and needing a way to provide detailed instructions and restrict input to valid values.
Observed behavior: Default query parameter prompts lack formatting options and cannot display detailed instructions, which makes them unsuitable for complex data collection.

Before you start

Ensure that your database tables and relationships are fully set up, and familiarize yourself with basic Form Design tools in Microsoft Access.

Solution 1Recommended

Use a Custom Form to Supply Query Parameters

Creating a dedicated parameter form is the standard approach to provide detailed instructions and enforce valid selections using combo boxes.

Since standard Access parameter prompts do not support rich text or lengthy descriptions, developers commonly use unbound forms to collect user input.

By replacing the default prompt with a form, you can freely add explanatory text labels and use combo boxes linked to lookup tables to prevent invalid data entry.

Create a New Unbound Form

Open your Access database, go to the 'Create' tab on the Ribbon, and click 'Form Design' to open a blank form.

Add Explanatory Text

Select the 'Label' control from the Design tab and draw it on your form. Type out the detailed explanations or instructions you want the user to read.

Insert Input Controls

Add Combo Boxes or Multi-select List Boxes from the controls menu. Use the wizard to link these boxes to your existing lookup tables so users can only pick valid options.

Name Your Controls

Open the Property Sheet for your new controls and give them recognizable names (e.g., 'cboSelectCategory') so they are easy to reference later.

Link the Form to Your Query

Open your query in Design View. In the 'Criteria' row under the target field, type the syntax =Forms!YourFormName!YourControlName to link the query to the form's input.

Improved User Experience: Using a form not only provides clear instructions but also significantly reduces query errors by forcing users to select from predefined lists.

Free Microsoft Office alternative

Need a Lightweight Alternative for Everyday Office Tasks?

While Microsoft Access handles complex database management, everyday document, spreadsheet, and presentation tasks don't require an expensive subscription. WPS Office provides a free, lightweight, and highly compatible alternative for all your core office needs.

Free, lightweight, and fast-performing office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Familiar tabbed interface ensures a seamless migration without a learning curveBuilt-in PDF editing and document conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Can I format the text in a default Microsoft Access parameter prompt?

No, the default bracketed parameter prompt (e.g., [Enter Start Date:]) is a plain dialog box. It does not support rich text formatting, line breaks, or lengthy instructions.

Why is my query not recognizing the form control parameter?

Ensure that your form is open when the query runs, and double-check your syntax. The correct format is =Forms!FormName!ControlName. If the form is closed, the query cannot read the values.

How do I run the query directly from the parameter form?

You can add a Command Button to your form using the Design tools. Use the Command Button Wizard to assign an action to the button, selecting 'Miscellaneous' > 'Run Query' and choosing your target query.

Office Quick Solutions