How to Show a Message for Empty Required Fields in Microsoft Access Forms
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.

- 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.
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.
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.
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.
Press Alt+F11 to open the VBA editor, then open the form module and create a validation subroutine that loops through Me.Controls.
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".
Call the validation subroutine from the form's BeforeUpdate or Close event so users are warned before the form updates or closes.

Allow Users to Save Unfinished Records and Complete Them Later
Use this option when records may be incomplete but still need to be kept, allowing users to reopen them later from a pending list.
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.

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.




