custom error message

[gunitinug]

i have table primary_tbl:


groupID autonumber
fullname short text

ive set fullname field to 'required'.

in a form, i want a custom error message when error occurs because i haven't set my fullname for the record.

how do i set a custom error message like "please set fullname"? thx

[aytee111]

In the BeforeUpdate event of the form, check the field and if it is null or blank then give an error message and set cancel=true.

[gwboolean]

Personally, I like using one of two approaches to messages. For any type of exception I generally will setup a try/catch and in the catch part I will use a message box that carries a message indicating the error, where it occurred and possible solutions. I keep the messages in a namespace that I have setup just for those and call the message from the message box. For something like what you describe I prefer to just have a label with .visible = false and .text = "whatever message needed". For your case I would setup a if branch in the event to make the label.visible = true.