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

  • Thread starter Thread starter adgorn
  • Start date Start date
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 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.
 
After some finagling, I figured out how to use the format event with some if
statements.
Thanks.
 
Back
Top