Others

How to Show a Message for Empty Required Fields in Microsoft Access Forms

Steven ParkerSteven Parker Nov 13, 2026 868 views

Question details

The user needs to validate required controls in a Microsoft Access form, show a message with the missing field name, and optionally allow users to save incomplete records for completion later.

How to Show a Message for Empty Required Fields in Microsoft Access Forms
Product
Microsoft Access
Device & OS
not provided
Scenario
Building or maintaining an Access form that must warn users about empty mandatory fields during save or close.
Observed behavior
The form should identify incomplete required controls, display the missing control name in a message box, and optionally save unfinished records for later completion.
Before you start

Open the form in Design View and confirm that every mandatory control has its Tag property set to a consistent value, such as Reqd or WarnUser.

Solution 1Recommended

Validate Tagged Required Controls and Display Missing Field Names

Use this approach to check mandatory fields when the user saves or closes the form and to show which controls still need data.

The Tag property is the easiest way to identify mandatory controls without hard-coding each control name. The validation loop checks only controls tagged with your chosen value and uses IsNull to detect empty values.

1
Open the form in Design View

Right-click the form in the Navigation Pane and choose Design View. Select each mandatory control, open the Property Sheet, and set the Tag property to Reqd or WarnUser.

2
Open the form module

Press Alt+F11 to open the VBA editor, then open the form module and create a validation subroutine that loops through Me.Controls.

3
Check tagged controls with IsNull

For each control, test whether its Tag property matches your marker and whether IsNull(ctrl.Value) is true. Build the message string by concatenating the control name, for example MsgBox "Incomplete form: " & ctrl.Name & " must be completed later", vbInformation, "Warning".

4
Run validation on save or close

Call the validation subroutine from the form's BeforeUpdate or Close event so users are warned before the form updates or closes.

Validate Tagged Required Controls and Display Missing Field Names
Message box displays correctly: When the string is built with & and quote marks around text, the warning shows the missing control name without a type mismatch.
Free Microsoft Office alternative

Free WPS Office Alternative for Microsoft Access Form Workflows

WPS Office is a free, lightweight alternative for the Word, Excel, and PowerPoint tasks around your Microsoft Access form workflow. It opens and saves Microsoft Office formats with a familiar ribbon interface, so you can migrate everyday documents easily while keeping Access for database form validation.

Free and lightweight Office suite for everyday document tasksOpens and saves Microsoft Office Word, Excel, and PowerPoint formatsFamiliar ribbon interface for easier migration from Microsoft OfficeLets you keep Microsoft Access for database forms while using WPS Office for related documents
microsoft office alternative - wps office

Frequently Asked Questions

How do I mark a control as required in Microsoft Access?

Open the form in Design View, select the control, open the Property Sheet, and set the Tag property to a consistent value such as Reqd or WarnUser.

Why does my MsgBox show a type mismatch when I include ctrl.Name?

The message string must be built with concatenation and proper quotation marks, for example MsgBox "Incomplete form: " & ctrl.Name & " must be completed later", vbInformation, "Warning".

Which form event should run the required-field validation?

Run the validation in the form's BeforeUpdate or Close event so it triggers when the user tries to save or close the form.

Can users save an incomplete record and return to finish it later?

Yes. Store the record ID in a separate pending-records table when validation fails, then reopen that record later from the pending list.

Does WPS Office include Microsoft Access database features?

No, WPS Office does not include an Access database replacement. You can use it for Word, Excel, and PowerPoint files while keeping Microsoft Access for database forms.