Example Apps for Businesses, Schools & Developers


Click any image to view a larger version

ColourConditions1 ColourConditions2 ColourPicker

Version 2.22           Updated 6 Nov 2021                 Approx 0.6 MB

This is a companion to the Colour Converter / Selector example application.

In earlier versions of Access, users were limited to 3 conditional formats
(or 4 colours including the default colour)

This limit applied whether using VBA or the conditional formatting wizard

With the release of Access 2010 , a significant improvement was made with up to
50 colour formats available using the conditional formatting wizard

. . . BUT the 3 colour limit still applies using VBA.

This example shows an alternative method.
An unlimited number of colour formats can in fact be obtained in VBA without using
conditional formatting.

Instead, the colour formats are stored in a lookup table.

This approach will work in any Access version (32-bit or 64-bit)
(at least from Access 2000 onwards)

The attached zip file includes both ACCDB & MDB (2000) formats

Click to download:     Colour Conditions     Approx 0.6 MB  (zipped)

Return to Example Databases Page Return to Top