Turning Off Required Field Message

[CharlieT302]

Hi folks,

I have a form that uses a field whose "Required" property is set to "Yes." I would like to turn off Access's default error message and replace it with my own.

Where do I go to do that...which Event..?

thanks

 

[RoyVidar]

Probably the forms on error event. Can't remember which number, but try just

[tt]msgbox dataerr[/tt]

within the event, then do something like

[tt]if (dataerr = <number you found>) then
msgbox "your custom message"
response = acdataerrcontinue
' last line tells access to not show default message
end if[/tt]

Roy-Vidar

 

[CharlieT302]

Thanks, it worked.