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  

Conditional formatting not quite working



 
 
Thread Tools Display Modes
  #1  
Old May 11th, 2010, 11:26 PM posted to microsoft.public.access.forms
Repent34[_2_]
external usenet poster
 
Posts: 7
Default Conditional formatting not quite working

I have a form that is generated by a query. The query is populated via
table.

I want all values in the report that are over 1.99% to show up as red.
Those values at 1.99% and lower should show up as green. IOW, percent
values from 0 to 1.99% are good values and show green. Anything at 2%
and over is bad, and should show up as red.

I've created conditinal formatting in several different ways, using
the options available under conditional formatting. It seems that no
matter what I select, greater than, equal to, etc, all the values
change to whatever the cond format is supposed to be.

Just seems the cond formating is not evaluating each value.

Should this be placed into the query somehow? Kind of confused on
this one. Thought it would be straight forward formatting.

chris
  #2  
Old May 11th, 2010, 11:53 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default Conditional formatting not quite working

On Tue, 11 May 2010 15:26:27 -0700, Repent34 wrote:

I have a form that is generated by a query. The query is populated via
table.

I want all values in the report that are over 1.99% to show up as red.
Those values at 1.99% and lower should show up as green. IOW, percent
values from 0 to 1.99% are good values and show green. Anything at 2%
and over is bad, and should show up as red.

I've created conditinal formatting in several different ways, using
the options available under conditional formatting. It seems that no
matter what I select, greater than, equal to, etc, all the values
change to whatever the cond format is supposed to be.

Just seems the cond formating is not evaluating each value.

Should this be placed into the query somehow? Kind of confused on
this one. Thought it would be straight forward formatting.

chris


Gee, you posted the same question just 2 1/2 hours ago. That's not a
lot of time to wait for someone to reply. We're all just volunteers
here with busy lives, just like you.
Perhaps if you had included in your message your exact conditional
formatting expression someone might have been willing to reply to the
specifics of your case, rather than take the time to respond in a
general way.

You're trying to color the control in a Report so that's where the
conditional formatting is done.

Sounds as though you are using Field Value Is to determine the
formatting rather than Expression Is. But then, I can't see your
computer so that's as a guess.

What are the actual field values used to represent the 1.99% in the
report?
0.0199?

Perhaps if you use Expression Is you will get a better result.

First Set the control color to Green.
Then:
Condition1
Expression Is
[ControlName] 0.0199
Select the Red color

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 




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 11:59 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.