display text box border only when text box value <>0

A

adgorn

For a text box in a report, I want a border when the value in the box <>0.
Can't figure out how?!
 
A

Allen Browne

A simple solution would be to use Conditional Formatting to change the color
of the text box. It's on the format menu, in report design view, when you
select the text box (or on the Design tab of the ribbon in A2007.)

If you do want to programmatically change the border, use the Format event
of the section containing the text box, to set its BorderColor and
BorderStyle.
 
A

adgorn

After some finagling, I figured out how to use the format event with some if
statements.
Thanks.
 
Top