Conditional Formatting on a report: Access 97

[Dr_Worm]

I have created a report in Access 97, with the following information:

Comp1, Comp2, Comp3, Comp4,…
Desp1, Desp2, Desp3 Desp4,….

They are all numeric fields. What I want to be able to do is have a boarder around “Desp1” if “Comp1” is greater than or equal to 1. The same for “Comp2” & “Desp2”, etc.

 

[garyd1234]

HI,
Make a border around each box and set its visible property to false. Then when one of your fields gets a value you could put code behind the on change event that says
if comp1 > whatever then border1.visible = true

try that.

 

[Swamp Thing]

There seems to be no way to apply conditional formatting to borders, but here is a workaround that uses the fill color of a textbox, which CAN be conditionally formatted.

Add an unbound text box with its height and width just a couple of points more than "Desp1". Select it, and click Format > Send to back. Set its fill color and outline to transparent.

Align this text box so it is right behind "Desp1"... you will just see its edges like a border around Desp1. Add conditional formatting to fill it in black if your condition is met.
i.e., Condition 1 : "Expression is" ([Comp1] >= 1) .. Black Fill

Hope this helps..
s.t.

 

[Dr_Worm]

Add conditional formatting to fill it in black if your condition is met.
i.e., Condition 1 : "Expression is" ([Comp1] >= 1) .. Black Fill

Forgive my lack of knowledge. I'm doing a lot of database stuff at the moment, and learning more and more as I go.

Where do I add the conditional formatting?

 

[Dr_Worm]

Something that just came to mind.

The default value of Comp1, Comp2.... is blank. Do I need to make the expression ([Comp1] IsNotNull)?

 

[Swamp Thing]

To conditionally format a control, click on it to select, then
Format > Conditional Formatting
from the main menu. (Design View, of course).

You don't need to test for Null values because the "greater than" test for numbers will return "true" only for non-null values.
However, if you did want to test for Non-null values, the condition would have been:

( Not ( IsNull ( [Comp1] ) ) )