Change error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gsnidow - 27 Nov 2007 18:44 GMT

Greetings folks. I have made a form's allowadditions property = false. I
have made navigation buttons also. Is there a way I can change the message
from 'You can't go to the specified record' when the user is on the last
record and they hit the next button, or when they are on the first record and
they hit the previous button? I think the messages may be confussing for
some users. I would rather have it say something like 'No more records'.
Thanks

Reply to this Message

Klatuu - 27 Nov 2007 19:12 GMT

You would have to trap for the specific error number in the click event of
the navigation buttons and present your own message using an error handler.

A better solution is to programmatically disable the buttons when they are
at the end or beginning of the recordset.

Signature

Dave Hargis, Microsoft Access MVP

> Greetings folks. I have made a form's allowadditions property = false. I
> have made navigation buttons also. Is there a way I can change the message
[quoted text clipped - 3 lines]
> some users. I would rather have it say something like 'No more records'.
> Thanks

Reply to this Message