Verifying user entered data

P

PiB311

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!
 
S

ssanderson

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.
 
P

PiB311

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?
 
P

PiB311

That will work, Thanks for your help!

ssanderson said:
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.
Click to expand...
 
Top