[AccessD] Color Field on Continuous Form based on Field Value

[David Emerson]

Hi Listers,

I am familiar with using Conditional Formatting to color a field based on a
fixed list of colors.

I have a continuous form where the user selects a different color for each
record using the color picker and storing the color value in a field.  This
color value is then used elsewhere in the program.

This means that the color can be any of hundreds of possible colours.

What I would like to do is have the background of the field (or something
else) colored in the color so the user can see what colors have been chosen
across all the records showing on the continuous form.  Does anyone know a
way of doing this?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand