On Tue, 9 Feb 2010 09:45:01 -0800, oldblindpew
wrote:

It's not odd to me. I think the Access team wants to provide you with
a set of base features which you can use to put together your app. I
would be HORRIFIED if a violation of validation would color the field.
In the rare case I want that, I would program it myself (e.g. using
VBA code in the control_BeforeUpdate or Form_BeforeUpdate).

Conditional Formatting is not primarily to be used for validation. It
has many other broader applications.

People search the newsgroups in many different ways. "this forum" is
not clear enough to me. Often I would use groups.google.com to start
my search.

-Tom.
Microsoft Access MVP


Please correct me on this: in a form control (Text Box) if you use a
Validation Rule, you can have an audible tone and a Validation Text, so it is
clear to the user that something is wrong, however, the offending field is
not highlighted. On the other hand, you can go with Conditional Formatting,
so the field changes appearance, but there's no alarm and no validation text!
Doesn't seem odd? How do you work around this?

This question has probably been asked and answered before, but I was unable
to locate the needle in the haystack. Could anyone give me a pointer on how
to do more than a one-word search on this forum?

Thanks,
OldBlindPew