Fix an Empty Message Box When Deleting Records in Microsoft Access
Question details
Identify why Microsoft Access displays an empty message box when a record is deleted.

- 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.
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.
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.
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.
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.
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.
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.

Check Related Records and Referential Integrity
Use this approach if the record has related child records that may prevent its deletion.
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.

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.




