Conditional Formatting In a Datasheet Form

[Guest]

Hi All,

I am trying to “Condition Format†a column on my form so it will highlight
the individual cell if another cell in the same column has the same value.
The form is in Datasheet view and it can not be changed from that due to the
way I built the database.

I have tried to build the condition format like so,

Condition1 “Field Value Is†“equal to†[Column Name]

and all it dose is it highlight the cell in the column when I input a record
into it, regardless if it is a duplicate or not.

Is there a way to accomplish this?

Thank you for your time,

Cage

 

[John W. Vinson]

Hi All,

I am trying to “Condition Format” a column on my form so it will highlight
the individual cell if another cell in the same column has the same value.
The form is in Datasheet view and it can not be changed from that due to the
way I built the database.

I have tried to build the condition format like so,

Condition1 “Field Value Is” “equal to” [Column Name]

and all it dose is it highlight the cell in the column when I input a record
into it, regardless if it is a duplicate or not.

Is there a way to accomplish this?

Not in datasheet view, as far as i know. Datasheets are of quite
limited utility.

But you say "it cannot be changed" - why on Earth not? Changing the
Default View of a form from Datasheet (which does not support
conditional formatting) to Continuous forms (which does) is not a
structural change to your data; it's a cosmetic change to a form.

John W. Vinson [MVP]