VBA conditional formatting

P

PsyberFox

Hi there,

I have read up about conditional formatting and understand the *concept*
clearly (I think). However, is it possible to display conditional formatting
of a subform in datasheet view on a form? If so, can someone please help me
with the VBA coding of this, as I need to have more than 3 (or 4 if default
is used) colours?

Thank you!
W
 
A

Allen Browne

If you use VBA code to set the properties of the controls (ForColor etc), it
will affect all rows of the datasheet, so no: that's not possible.

You can use that approach in a report: that's probably your only option if
you need more than 3 formats.
 

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

Document Merge Formatting Issue 0
Printing Outline view - formatting lost 0
change captions with conditional formatting 2
Conditional Formatting 0
Conditional Formatting with VBA 4
ASK Field Formatting 1
Conditional Formatting 3
Word VBA (probably) conditional paragraph spacing based on preceding paragraph style 0

Top