Others

Fix an Empty Message Box When Deleting Records in Microsoft Access

Emma BrownEmma Brown Nov 13, 2026 869 views

Question details

Identify why Microsoft Access displays an empty message box when a record is deleted.

Fix an Empty Message Box When Deleting Records in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
A user attempts to delete a record using an Access form or delete button.
Observed behavior
An empty message box appears during deletion. Custom error handling or related records may be involved.
Before you start

Identify the form and delete button involved, and make sure you can access the database's VBA code and relationships. Ask the database developer for help if you do not have permission to inspect or change them.

Solution 1Recommended

Debug the Access Delete Button and Its Error Handler

Use this approach to find the code that displays the empty message and identify the underlying error.

1
Open the button event

Open the form in Design View, select the delete button, and open its Property Sheet. On the Event tab, locate On Click and use the build button to open its VBA event procedure.

2
Set a breakpoint

In the VBA editor, click the first executable line of the delete procedure and press F9. Return to Form View and click the delete button to pause the code.

3
Step through the code

Press F8 in the VBA editor to run the procedure one line at a time. Follow any error-handling branch until you find the MsgBox call or other code that displays the blank dialog.

4
Inspect the error message

Check the expression passed to MsgBox and inspect the error details in the handler. Update the handler to display a meaningful error description, such as Err.Description, and investigate the error that triggered it.

Debug the Access Delete Button and Its Error Handler
Check related forms too: The error may originate in a subform or another procedure called by the delete button, rather than in the button's code itself.
Free Microsoft Office alternative

Work With Exported Access Data in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Export Access data to an Excel file to review it in WPS Spreadsheets; WPS Office does not fix Access database errors or replace Access relationships and VBA.

Review exported Access data in WPS SpreadsheetsCompatible with Microsoft Excel XLSX and Word DOCX formatsFamiliar interface for an easier transition from Microsoft OfficeFree, lightweight tools for everyday documents and spreadsheets
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access show a blank message when I delete a record?

Custom error-handling code may display a MsgBox with empty text. Set a breakpoint in the delete button's On Click procedure and step through the code to find the call and its underlying error.

Can related records prevent a parent record from being deleted?

Yes. If referential integrity is enforced, Access can prevent deletion when related child records exist. Check the subforms, child tables, and Database Tools > Relationships.

Should I turn on cascade deletes?

Only if automatically deleting the related child records is intended and safe. In Database Tools > Relationships, double-click the relevant relationship to review or change Cascade Delete Related Records.

Can WPS Office fix the empty Access message box?

No. The Access database's VBA code or relationships must be checked in Access. You can export data to an Excel file and review it in WPS Spreadsheets, but that does not repair the database.