Change the MsgBox Title

[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

 

[Jeanette Cunningham]

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

 

[Rob Parker]

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