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



"magicdds-" <(E-Mail Removed)> wrote in message
news:AF22CAAE-91D7-4AF3-8923-(E-Mail Removed)...
> 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
>

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

"magicdds-" <(E-Mail Removed)> wrote in message
news:AF22CAAE-91D7-4AF3-8923-(E-Mail Removed)...
> 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
>