Color pallet and picker (1 Viewer)

[jfgambit]

A car company currently has a Color field in main table of their database that is linked to a sub table containing a list of colors (black, red, blue, yellow, etc). I want to change it so that on the Main form, when a user clicks a command button the color pallet appears and they can select the color from the already preset colors or customize the color and then have the color number stored in the color field. Does anyone know if this is possible?

 

[Fizzio]

A possible way of doing this is to create your own colour palette using an unbound form and either textboxes or labels with each of them filled with the colour of your choice.
When the command button is pressed to select the colour, it opens this popup form and on the on_click event of the coloured control, passes the value of the colour to the previous form and closes the palette.

Hope this makes sense.

As far as creating new colours, it depends if you want an actual colour representation or simply a text description. The former would be tricky (although propably not impossible!)

 

[Fizzio]

After a bit of tinkering and code ripping, here is an example of how you can create your own colour library, using the colour picker.

 

[jfgambit]

Fizzio:

WOW!!!

Great Job...this is exactly what we needed! Thanks!

 

[Fizzio]

Glad you like it