Verifying user entered data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
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?
 
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...
 
Back
Top