tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

MS Access: MsgBox Arguments

The MsgBox function is one of the most commonly used functions within Access. It is a method of interacting with the user during a session. Therefore, you must accurately select the buttons for your MsgBox. Below is a table that lists all of your MsgBox options.

Applies To

Arguments

The arguments for MsgBox are as follows:

Constant Value Description
vbOkOnly 0 Displays 1 button - OK (default value)
vbOkCancel 1 Displays 2 buttons - OK and Cancel
vbAbortRetryIgnore 2 Displays 3 buttons - Abort, Retry, Ignore
vbYesNoCancel 3 Displays 3 buttons - Yes, No, and Cancel
vbYesNo 4 Displays 2 buttons - Yes and No
vbRetryCancel 5 Displays 2 buttons - Retry and Cancel
vbCritical 16 Displays a critical message
vbQuestion 32 Displays a question
vbExclamation 48 Displays a warning message
vbInformation 64 Displays an information message
vbDefaultButton1 0 Displays 1 button - OK which is the default
vbDefaultButton2 256 Second button is default
vbDefaultButton3 512 Third button is default
vbDefaultButton4 768 Fourth button is default
vbApplicationModal 0 Displays 1 button - OK. Modal message box for the application.
vbSystemModal 4096 Displays 1 button - OK. Modal message box for the system.
vbMsgBoxHelpButton 16384 Displays 2 buttons - OK and Help.
vbMsgBoxSetForeground 65536 Displays 1 button - OK. Message box window becomes the foreground window.
VbMsgBoxRight 524288 Displays 1 button - OK. The text message is right aligned.
VbMsgBoxRtlReading 1048576 Displays 1 button - OK. Used for Hebrew and Arabic systems.

Example

Here is an example of how you can use a MsgBox.

Dim LResponse As Integer

LResponse = MsgBox("Do you wish to continue?", vbYesNo, "Continue")

If LResponse = vbYes Then
   {...statements...}
Else
   {...statements...}
End If

You've declared a variable called LResponse that stores the result from the MsgBox function. If the user clicks on the Yes button, LResponse will contain the vbYes value and if the user clicks on the No button, LResponse will contain the vbNo value.

See a list of the MsgBox return values (ie: vbYes, vbNo, etc).