Change message on dialog box (1 Viewer)

vent · Oct 17, 2017

Hi everyone

Just out of curiosity, is it possible to change the text in the prompt message? I have a form where users fill things out and I set this particular field as required. If the user forgets to add a value, they are prompted with the message "You must enter a value in the 'tblAgencyInformationNew.Agency' field. I was wondering is there way I could simply remove the tblAgencyInformationNew part of this message?

Thank you.

pbaldy · Oct 17, 2017

One way:

http://www.baldyweb.com/BeforeUpdate.htm

arnelgp · Oct 17, 2017

use the Form's Error Event, eg:

Code:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    MsgBox Err.Number & ": " & Err.Description
    Response = acDataErrContinue
End Sub

Change message on dialog box (1 Viewer)

vent

Registered User.

pbaldy

Wino Moderator

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread