J
John Geddes
Using Access 2000:
I have a conditionally-formatted field that sits in front of another
conditionally-formatted field.
I can happily change the foreColor and backColor of the front field with
Conditional Formatting. But when the alternative formatting is applied,
the Border Style is also changing - from Transparent (its normal
setting) to Solid.
(Usually I could work around this by setting the Border Color to the
same colour as the background behind the field, but in this case I need
that background to change from light to dark according to another
condition, so this approach will not work.)
There are no Border settings within FormatCondition. Is there any other
way of keeping the Border Style transparent?
John Geddes
England
I have a conditionally-formatted field that sits in front of another
conditionally-formatted field.
I can happily change the foreColor and backColor of the front field with
Conditional Formatting. But when the alternative formatting is applied,
the Border Style is also changing - from Transparent (its normal
setting) to Solid.
(Usually I could work around this by setting the Border Color to the
same colour as the background behind the field, but in this case I need
that background to change from light to dark according to another
condition, so this approach will not work.)
There are no Border settings within FormatCondition. Is there any other
way of keeping the Border Style transparent?
John Geddes
England