A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

color pallet option in form



 
 
Thread Tools Display Modes
  #1  
Old November 10th, 2006, 06:11 PM posted to microsoft.public.access.forms
Anne
external usenet poster
 
Posts: 445
Default 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  
Old November 10th, 2006, 07:32 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.