Conditionally format datasheet cell

U

UsenetUser

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

Thank you.
 
T

Tom van Stiphout

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

-Tom.
Microsoft Access MVP
 
U

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.
 
D

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?
 
Top