Version 2.21 Updated 31/12/2020
Click any image to view a larger version ...
This is a simple application to demonstrate two different methods for selecting and converting colours between the three different formats used by Access: OLE, RGB & HEX
1. The colour converter utility can be used to:
a) select a colour and view its OLE colour, RGB and HEX values
b) convert colour values between these formats
his DevHut website
2. The colour categories utility is intended to assign colours to particular types of event
For example, I use this in a calendar event application.
This item also includes the use of the MS colour picker control
To use either of these in your own applications:
1. Colour converter
Copy the form frmColourConverter and module modColourConvert
2. Colour categories
Copy the form frmColourCategories, report rptCalendarCategories and module
v2.2 08/03/2020: Fixed issue with the colour picker dialog in 64-bit Access.
v2.21 26/12/2020: Fixed 2027 date error! Thanks to Dave Thompson for spotting it!
Click to download Colour Converter v2.21 Approx 0.7 MB (zipped)
See this post by The_Doc_Man at Access World Forums for a very clear & detailed
explanation of how RGB & hex colour values are related.
See also this companion example: Colour Conditions.
This shows how to obtain an unlimited number of colour formats without using
conditional formatting either in VBA or by using the wizard.