How to customize "access denied" message?

It's been a long time since I looked at a switchboard form, but
it probably has code like this:

On Error GoTo Err_Command0_Click

.....

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click


If it does not have "On Error", then you will need to add it.

The MsgBox is what displays the error message. In this example
it is displaying the Description as you described.

If you do not already have "On Error" and "MsgBox" in your switchboard
code, Access is using the default code for "On Error" and "MsgBox". The
default can be replaced as shown. Instead of using the control name in
each function, I normally just use

On Error Goto Catch
and
Catch:

(david)

"Craig" <(E-Mail Removed)> wrote in message
news2777F6F-4B8B-4AF7-B7B8-(E-Mail Removed)...
> "david" wrote:
>
>> How are they opening the form? You have more control if you give
>> them a button to push instead of letting them select forms from the
>> database window.
>>
>> (david)
>
> David,
>
> When the database opens, a "main menu" switchboard form appears.
>
> From that form they can click one of four buttons to open additional
> forms.
> Depending on the user's role, he or she might have access to one, two,
> three,
> or all four forms.
>
> I've set up the security correctly and the generic system "access denied"
> message appears at the correct moments --- I'd just like to customize that
> message. Not a showstopper, just a nice-to-have.
>
> Thanks,
> Craig