[AccessD] Reports - Conditional formatting question

Hi Bruce

If the background is transparent then you can't apply a colour - well you can
but it won't be seen 

So you need to test for your condition in code then you have to set the
.background = 1 (Normal) as well and vice versa when turning it off -
.background =0 if your condition is not met

This is gonna fail in a continuous form by the way a it will apply the
.background to all field in the continuous list

Haven't tested it but hope this helps

Gimme a yell and I will show you a cool way I handle marking records as
"current" - or not using conditional formatting


See ya

DD
-----Original Message-----
From: Bruce Bruen [mailto:bbruen at unwired.com.au] 
Sent: Wednesday, 28 March 2007 10:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Reports - Conditional formatting question

1)  This is driving me beserque!!!
2)  It was a short trip.

In band X I have a text field (numeric).
Its' background style, like all the others in the band, is transparent.

If its' value is in error, i.e. value=0, then I want to set its' background 
colour to vbBloodyBrightRed!
If its' not in error then I want to leave its' background transparent.

These seem to be incompatible.  If I change one the the other changes for the 
rest of the report, viz: if I impose conditional formatting then the rest of 
the report gets a bright white background,  if I set the backgraound 
transparent then the condition dissappears.

BTW: I have tried setting the formatting in both the design and via code.

Ooooh.  

It would be really nice to be able to set the LABEL background at the same 
time.


BTW, the field is a dCount value if that's any more information.  Basically, 
its a test coverage report, we have 1.4 gazillion use cases each having 0..* 
active test cases.  ->

	Report
		for each use case in schedule
			"display" [UC].[details] & Count([UC].[activetestcases])
		next
	end

So out of 300 odd test cases it's a bit hard to see the ones we've missed.
The band fields are transparent because...
we also want to highlight bands that are relevant vs ones that aren't.  (So 
the band background is shaded 5% for the ones that aren't, and by 
GeeWillikers that works goodbut.

Any ideas?  Any previous infuriation?  Any bar?  

Final BTW: AXP

-- 
regards

Bruce
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.20/736 - Release Date: 27/03/2007 4:38
PM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.20/736 - Release Date: 27/03/2007 4:38
PM