DoCmd.SetWarnings method (Access)
The SetWarnings method carries out the SetWarnings action in Visual Basic.
Syntax
expression.SetWarnings (WarningsOn)
expression A variable that represents a DoCmd object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| WarningsOn | Required | Variant | Use True (1) to turn on the display of system messages and False (0) to turn it off. |
Remarks
Use the SetWarnings method to turn system messages on or off.
If you turn the display of system messages off in Visual Basic, you must turn it back on, or it will remain off, even if the user presses Ctrl+Break, or Visual Basic encounters a breakpoint. You may want to create a macro that turns the display of system messages on and then assign that macro to a key combination or a custom menu command. You could then use the key combination or menu command to turn the display of system messages on if it has been turned off in Visual Basic.
Example
The following example turns the display of system messages off.
DoCmd.SetWarnings False
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for