I have a report with a header that different people will access using a form where they select their criteria then preview.
Different users need to distinguish their report by assigning a different color to the "Back Color" property of the header control called "CtrlHeader".
I don't want to hard code the "Back Color" values (e.g. #00B7EF), but would like the user to select a color from a palette of some sort (Windows or Access color picker), store the value they select (e.g. #00B7EF) and pass it along to the "Back Color" property of the header control "CtrlHeader".
Step 1 - add control on form to allow user to select color.
Step 2 - open report and pass previously selected color value to back color property of control