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

 

   NOTE:

   This is a modified version of a utility by Daniel Pineault which is available at 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

   modColorChooser

 

 

UPDATE: v2.1 06/03/2019:

Now also works in 64-bit Access / explicity defined all variables in modColourconvert

   

Click to download Colour Converter v2.1      Approx 0.7 MB  (zipped)