required error message dialogue

[ralphus]

When setting a field as required in design view, how do you change the error message for when a user has not filled the field

 

[M8KWR]

If you want to do that then you would have to do you own I believe.

You would have to disable the field properties in the table design to allow null values.

Then you would have to write some code so if a user left the field and it was blank it made them fill it in. But this way users can get around it.

 

[RoyVidar]

It will probably produce a form error, where you can use the forms on error event to substitute the default message with your own. I think it is dataerr, but to be sure, enter a

[tt]msgbox dataerr[/tt]

within the routine to test

[tt]private sub form_error(dataerr as integer, response as integer)
if dataerr=3314 then
msgbox "my custom message"
response=acdataerrcontinue ' turn off default message
end if
end sub[/tt]

Roy-Vidar