Checking Required Fields have been entered

  • Thread starter Thread starter S Price
  • Start date Start date
S

S Price

Is there a way to check that all required fields have been
completed on a form?

I know that Access will automatically return an error if
all required fields have not been completed but I'm
wanting to add a indicator to let the user know if they've
completed everything
 
Hi. I usually put in an if then else statment for required
fields. something like
if isnull(thiscontrol) then
msgbox("input something")
thiscontrol.setfocus
exit code
end if
if you have a lot of required fields you might wish to use
select case instead.
 
Thanks for the reply.

I have got quite a few fields and had thought of using the
IsNull function but wondered if there was a quicker way.

I also use the Select Case statement for some more
detailed error handling but don't think that could do what
I want it to.

Think I'll just have to write lots of code ;-)
 
Back
Top