Modifying a color pallet for a form will have no effect on the report. A
Color Pallete or Paint Pallate property belongs only to the object.
If you are wanting to change the font color for object on a report. you will
have to change the pallet in the report. The problem here is that you can
only change it in Design view.
If you just want to assign a font color on a report, it has to be done in
the On Print event of the section of the report the controls are in that you
want to change.
Now, to be able to get the info in the form and pass it to the report, there
are a couple of ways to do this. If you are using 2003 (I think 2002 also,
but I am not sure), you can use the OpenArgs argument of the OpenReport
methods to pass the value to the report and the report can use its OpenArgs
property to set the control properties. If you are not using 2003 in 2003
format, the technique would be to create an invisible control on the form and
store the value for the report in that control. Then in the Print event
mentioned previously, refer to the form control to get the value. The form
must still be open for this to work.
Me.SomeControl.ForeColor = Forms!MyFormName!txtColorBox
