API available so VBA code can get a color value?

[GraeagleBill]

Is there anyone with code that can select a color and get its Long value returned?


I just want to open the Access color chart and get the value associated with the selection.
Like:

Dim lngColorval as long
lngColorval = ColorPick() 'Where ColorPick opens the Access menus where a user can select a color.



Thanks,
Bill

[Gicu]

Here are some links for you:
https://www.access-programmers.co.uk...picker.271714/
https://social.msdn.microsoft.com/Fo...orum=accessdev
https://social.msdn.microsoft.com/Fo...orum=accessdev
https://www.devhut.net/access-color-picker/

[isladogs]

Colour Converter (isladogs.co.uk)

[GraeagleBill]

Hi Colin,
Winzip V26 getting errors trying to extract the accdb.
Bill

[isladogs]

Just checked the zip file. Windows extracts the ACCDB file without issues. I no longer use Winzip.

[GraeagleBill]

Strange the WinZip hit an error. I just used WE to open the ZIP and accdb opened up as you posted. A lot of usable choices posted in the thread, I'll select from the list of options there.
Thanks,
Bill

[isladogs]

You will need the colour converter app.