Changing a default warning message

Question

Hello:

On one of the tables in a Db I've created I've made Last Name, and First Name required fields. It works like I want it to, but is there a way to change the message box below to read something such as "You must enter a First Name for this candidate" instead of 'You must enter a value in the TblCanC.FN field"

Thank you,

Robert

Answer 1

You have to write code using the code builder, not just enter a MsgBox function in the event box.

The messages displayed for Required fields that are not entered occur when you try to save the record on the form. So you would have to use a Form event not a Control event.

But a better option would be to use the Controls Before Update or On Exit events.

Then you would use code like:

If Me.controlname = Null then

   MsgBox "You must enter a value"

   Cancel = True

   Me.Controlname.SetFocus

End If

Answer 2

You would write your own content. Something like:

MsgBox Prompt:="You must enter a name in the First Name field", Buttons:=vbAlert + vbOkOnly, Title:="Required Value Missing"

Answer 3

Hello There.

I placed the message box in "before update" event. I still get the same message. Is there a way to adjust the default message box?

Thank you,

Robert

Answer 4

Hello There.

I placed the message box in "before update" event. I still get the same message. Is there a way to adjust the default message box?

Thank you,

Robert

Answer 5

Yes, you can do this with a custom message box from within the Control's Before Update event or from within the Form's Before Update event.