If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
color pallet option in form
I am creating a form in Access 2003 and would like to add an option to change
the font color to the report that is selected on the form. The report is for labels and I would like to add a color pallette to the form as an option. How would i do this? |
#2
|
|||
|
|||
color pallet option in form
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 "Anne" wrote: I am creating a form in Access 2003 and would like to add an option to change the font color to the report that is selected on the form. The report is for labels and I would like to add a color pallette to the form as an option. How would i do this? |
Thread Tools | |
Display Modes | |
|
|