Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Conditional Formatting Options in Access 2007

Status
Not open for further replies.

jaaret

Instructor
Jun 19, 2002
171
How do I change the Conditional Formatting color palette in Access 2007. Is it possible, or do I have to resort to VBA to have custom Conditional Formatting color choices?
 
How are ya jaaret . . .

In VBA, using the [blue]FormatConditions Collect[/blue] you can use any colors you like! [thumbsup2]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
So the answer is you can NOT customize the palette of colors in Access 2007 (the way you can change the defaults in Excel) and it MUST be done with VBA. Is this correct?
 

[green]Yes![/green] [thumbsup2]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top