Ignore Blank/Data Validation

  • Thread starter Thread starter LeAnn
  • Start date Start date
L

LeAnn

Can anyone tell me how that feature is suppose to work?

If you uncheck the "Ignore Blank" option when creating
data validation, I would assume it would alert the user if
they left that cell blank. This doesn't seem to do that.
When does "Ignore Blank" get triggered? I understand how
Access works when making a field required but Excel
doesn't have the same event driven programming.

Thanks and Happy Holiday!
LeAnn
 
Data Validation can't be used to force an entry. A user can always select a
cell and move on without making an entry.

The Ignore Blank option, if unchecked, prevents the user from "entering a
blank", say by pressing F2 and Enter or by backspacing over an entry. The
point of this totally eludes me as a Delete is not blocked. Maybe there is
something useful this does that I haven't discovered however.
 
Back
Top