Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Want to change colors of text items in reports

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  Forms load slowly (Calculating. . . .) after data..  
Author Message
Strangeone_99

External


Since: Jan 7, 2009
Posts: 1



(Msg. 1) Posted: Wed Jan 07, 2009 11:53 am
Post subject: Want to change colors of text items in reports
Archived from groups: microsoft>public>access (more info?)

In a database I have a field with a drop down box that has 3 possible text
answers. When one of these answers is selected, I would like to have a
different color for each answer in the report. Example: Priority code with a
selection of 1, 2, 3. In the report I would like to have 1 as red, 2 as green
and 3 as blue. Is this possible and if so do I have to do this in code or
just within normal access functions

 >> Stay informed about: Want to change colors of text items in reports 
Back to top
Login to vote
MikeJohnB

External


Since: Nov 26, 2008
Posts: 11



(Msg. 2) Posted: Wed Jan 07, 2009 12:41 pm
Post subject: RE: Want to change colors of text items in reports
Archived from groups: per prev. post (more info?)

This is possible using conditional formatting on the reports control
[Priority code]

Select the control with your report in design mode and then select
conditional formatting.

Set Condition to "Field Value Is"
In the next box to the right select "equal to"
In the next box to the right enter "1"

No Quotes

Now select the backcolour Red

Now press the add button
Repeat the above for the second condition of 2

Press add again and repeat the above for the third condition of 3

You can also do the same with VB but it is mush easier using the conditional
formatting for up three conditions

Does this help???

Kindest Regards

Mike B

 >> Stay informed about: Want to change colors of text items in reports 
Back to top
Login to vote
MikeJohnB

External


Since: Nov 26, 2008
Posts: 11



(Msg. 3) Posted: Wed Jan 07, 2009 12:51 pm
Post subject: RE: Want to change colors of text items in reports
Archived from groups: per prev. post (more info?)

I will try sending this again.

Your requirement can be met using Conditional Formatting on the control
Priority Code with your report in design mode.

Select the Control Priority Code
Select Conditional Formatting
In the first box on the format menu set to

Field Value is

In the next box, select Equal to from the selction

Type 1 in the next box across to the right (Three Boxes to fill in)
Now select the back colour for the control, the text colour (red) and text
style from the selections available.

Now press the add button and repeat the above steps but enter the value 2 in
the rightmost box and set for the second colour

Press the add button for the third option and set the colour/font styles for
the third condition.

This is by far the easiest way for up to three options

I hope this helps?????

Kinedest regards

Mike B
 >> Stay informed about: Want to change colors of text items in reports 
Back to top
Login to vote
Strangeone_99

External


Since: Jan 7, 2009
Posts: 1



(Msg. 4) Posted: Wed Jan 07, 2009 2:14 pm
Post subject: RE: Want to change colors of text items in reports
Archived from groups: per prev. post (more info?)

Thanks man, It helps a lot, I'm a newbe to access and am starting to like
some of the stuff I see that it can do.

"MikeJohnB" wrote:

> I will try sending this again.
>
> Your requirement can be met using Conditional Formatting on the control
> Priority Code with your report in design mode.
>
> Select the Control Priority Code
> Select Conditional Formatting
> In the first box on the format menu set to
>
> Field Value is
>
> In the next box, select Equal to from the selction
>
> Type 1 in the next box across to the right (Three Boxes to fill in)
> Now select the back colour for the control, the text colour (red) and text
> style from the selections available.
>
> Now press the add button and repeat the above steps but enter the value 2 in
> the rightmost box and set for the second colour
>
> Press the add button for the third option and set the colour/font styles for
> the third condition.
>
> This is by far the easiest way for up to three options
>
> I hope this helps?????
>
> Kinedest regards
>
> Mike B
> --
> Advice to Posters.
> Check your post for replies or request for more information.
> Consider providing some feed back to the response you have recieved.
> Kindest Regards Mike B
>
>
> "Strangeone_99" wrote:
>
> > In a database I have a field with a drop down box that has 3 possible text
> > answers. When one of these answers is selected, I would like to have a
> > different color for each answer in the report. Example: Priority code with a
> > selection of 1, 2, 3. In the report I would like to have 1 as red, 2 as green
> > and 3 as blue. Is this possible and if so do I have to do this in code or
> > just within normal access functions
 >> Stay informed about: Want to change colors of text items in reports 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Setting System Colors - Is there a way to change the window header and border color from within Access? Thanks for your help!

Blank Reports to not open - Hi I have 3 reports which open from a macro. I would like the reports to be displayed if there is information, however if the report is blank I don't want to open it. Is there a setting which stops blank reports from openning?

Saving Reports Outside Of Access - Can someone tell me if it is possible by code to Save a Report As a Data Access Page through VBA? And if so, could you give me an example of the code? I would like the user to select the report from a switchboard, have it open in Preview mode and on...

Ensuring uniform control width on forms and reports - This utility ensures you have uniform control width on forms and reports. This example shows the Unit Number as found in many forms and reports through out the Granite Fleet Manager. Other examples might be part numbers, serial numbers, license plat...

Selecting Listbox items in code - I am trying to use a listbox click event to run VBA code which selects an item in another listbox. Private Sub List0_Click() Select Case List0.Value Case "CR2" List2.SetFocus List2.ListIndex = 0 Case &q...
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]