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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
IF and AND statement 9
Conditional Formatting on non-numerical value 3
Is there a way to count colored cells that are conditionally formatted? 3
Conditional Formatting 3
Action on record change from split form? 2
Make current record next conditionally formatted row 9
Conditional Formatting on a Subform 2

Top