change BackColor

  • Thread starter Thread starter ChuckL
  • Start date Start date
C

ChuckL

I posed a question yesterday about changing the color of
the background in a text box on a form based on whether it
is "Yes" or "No". I received a good response, however,
I'm running Access 97 not 2000, so I can't use the
conditional formatting property. Is there any way to do
this in 97? See below?

Thank you
 
ChuckL said:
I posed a question yesterday about changing the color of
the background in a text box on a form based on whether it
is "Yes" or "No". I received a good response, however,
I'm running Access 97 not 2000, so I can't use the
conditional formatting property. Is there any way to do
this in 97? See below?
Click to expand...

The 97 work-around is to make the TextBox have a clear background and then
place "behind" it another TextBox which uses an IIf() expression and a
symbol font that includes a square block. I use the Terminal font and the
character Û. Below is an example expression.

=IIf([SRLSC]=0,"",String(10,"Û"))

The above evaluates [SRLSC] and either displays a blank or 10 instances of
Û which in the Terminal font is displayed as a square block. In my case I
made the ForeColor yellow so the result is a yellow background that shows
up behind the other TextBox whenever [SRLSC] is not equal to zero.
 
Back
Top