Change the MsgBox Title

  • Thread starter Thread starter magicdds-
  • Start date Start date
M

magicdds-

When a user types in data in a form which is inappropriate, The Before Update
property has code to check the entry, and if it is not appropriate, I use
MsgBox to tell the user to re-enter the data.

The popup MsgBox has a Title "Microsoft Office Access".
Is there a way to change the title or leave it blank?

Thanks
 
Msgbox "Please re-enter the data", vbInformation, "Invalid entry"

The above will show the message box with a title of Invalid entry.
It will also show a button with and i on it.

The Msgbox statement has 3 arguments,
1. the prompt or message
2. the buttons to show
3. the title

If you leave the title argument blank, the title is Microsoft Office Access.

Jeanette Cunningham
 
The third parameter of the MsgBox method is the title string:

MsgBox "My message", [button/icon constants], "My Title"

See help for the built-in constants/values for the optional [button/icon
constants] section.

HTH,

Rob
 
Back
Top