Conditionally format datasheet cell

  • Thread starter Thread starter UsenetUser
  • Start date Start date
U

UsenetUser

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

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

-Tom.
Microsoft Access MVP
 
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.
 
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?
 
Back
Top