Verifying user entered data

[Guest]

Hello,

I am trying to figure out the best way to first, find all null or empty
fieds that a user should have completed, and then highlight those fields.
This would be On Click for a button that appends data to a table (for an
unbound form). After these actions are complete, a msgbox would be populated
to instruct the user to fill in highlighted fields.

I was thinking a loop would best serve my purpose but any suggestions are
welcome.

Thanks!

 

[Alex Dybenko]

Hi,
I think you can use BeforeUpdate from event to check if required fields are
entered and then highlight them.
if all, say textboxes, should be filled - then of course you can use loop

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

What about conditional formatting on all the fields you require? Of course,
this would highlight the empty fields before you even start but that might be
valuable too.

 

[Guest]

Let's say I have 5 fields, combo1, combo2, combo3, combo4, and combo5. how
would I contruct the loop verbage to search for null and empty values then
then change the formating?

 

[Guest]

That will work, Thanks for your help!

What about conditional formatting on all the fields you require? Of course,
this would highlight the empty fields before you even start but that might be
valuable too.

 

[Alex Dybenko]

Hi,
like this:

for i = 1 to 5
if isnull(me("combo" & i)) then
me("combo" & i).backcolor=vbred
exit for
next i

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com