Reports

[Pat]

I would like to be able to format/change the colour of a
cells border within a report depending upon the contents
of the cell, i cannot see how to do it

Conditionally formatting only seems to allow me to change
colour of the contents not the cell border..


any thoguhts

 

[fredg]

I would like to be able to format/change the colour of a
cells border within a report depending upon the contents
of the cell, i cannot see how to do it

Conditionally formatting only seems to allow me to change
colour of the contents not the cell border..

any thoguhts

In your report, code the Detail (or whichever section the control is
in) Format event :
If [SomeControl] = criteria Then
[SomeControl].BorderColor = vbRed
Else
[SomeControl].BorderColor = vbBlack
End if

Of course you must make sure the control's BorderStyle property is NOT
set to Transparent.