Fun with Conditional Formatting

  • Thread starter Thread starter Waterman
  • Start date Start date
W

Waterman

Conditional Formatting works great when it comes to
changing the color and fonts of objects on a form. But
what if I wanted to render an object invisible based on
an expression?

Rather than rely on the built-in function of Conditional
Formatting, is there a way that I can write the code
instead and accomplish the same thing?
 
Waterman said:
Conditional Formatting works great when it comes to
changing the color and fonts of objects on a form. But
what if I wanted to render an object invisible based on
an expression?

Rather than rely on the built-in function of Conditional
Formatting, is there a way that I can write the code
instead and accomplish the same thing?
Click to expand...


In single form view, you can use the Current event with code
like:

Me.textbox.Visible = (true/false expression)

I don't think this can be done with a form in DataSheet
view.

The only reasonale way to do this in a continuous form is to
use conditional formatting and set both the ForeColor and
Back Color to the same color as the form's BackColor (yuck).
 
Back
Top