Customizing Built-in Access Message Boxes

[Marckas]

Hello, I just wanted to change the text of one of the built-in messageboxes that Access has. There is a message box that pops-up saying "You cant go to the specific record. You may be at the end of a recordset." I want the change the text for this. Appreciate the help =)
Munaf

 

[gusbrunston]

Hi:

You can "trap" the particular error number, and substitute your own message box. Something like:

(Substitute the error number you want to trap for "9999".)

If Err.Number = 9999 Then
  MsgBox "Now hear this!",_
    vbOKOnly, "My own message"
  Exit Sub
Else
  MsgBox Err.Description
End If

And, you should provide error protection in the event are other errors that you don't trap.

I hope this is helpful.

Gus Brunston An old PICKer, using Access2000.

 

[gusbrunston]

Hi again:
The error number you need is 2105. Gus Brunston An old PICKer, using Access2000.

 

[Marckas]

Thanx a lot Gus, it did work. I really apperciate it.
Munaf