Conditionally format datasheet cell

[UsenetUser]

Any way programtically in Access 2007 to change the background color
of a datasheet cell conditionally depending on its contents?

Thank you.

 

[Tom van Stiphout]

Yes! Check out "conditional formatting" in the help file.

-Tom.
Microsoft Access MVP

 

[UsenetUser]

Did that. Doesn't say anything about doing it programatically, but
even more important, while I have it working in form view, can't get
it going in datasheet view, nor did I see any references to using it
in a datasheet.

 

[Douglas J. Steele]

You're doing formatting on a control. Whether you're using a single control
(i.e. in single form view) or multiple versions of the same control (i.e. in
datasheet or continuous form view), it works the same.

Why do you need to do this programmatically?