Conditional Formatting

R

Resti M. Guay

hi,
i need a complete code that can change the BackColor of the TexBox found in
the Detail of my report and i want it this way:
if my TextBox1 value is greater than my TextBox2 value then i want the
BackColor of TextBox1 to become Red.
thanks,
resti
 
F

fredg

hi,
i need a complete code that can change the BackColor of the TexBox found in
the Detail of my report and i want it this way:
if my TextBox1 value is greater than my TextBox2 value then i want the
BackColor of TextBox1 to become Red.
thanks,
resti
Click to expand...

What version of Access?
Access 2000 or newer?
Select TextBox1.
Click on Format + Conditional Formatting
For Condition1 select
Field Value Is
Greater Than
[TextBox2]

Select the backcolor.
Click OK
 
R

Resti M. Guay

Thanks Fredg

fredg said:
hi,
i need a complete code that can change the BackColor of the TexBox found in
the Detail of my report and i want it this way:
if my TextBox1 value is greater than my TextBox2 value then i want the
BackColor of TextBox1 to become Red.
thanks,
resti
Click to expand...

What version of Access?
Access 2000 or newer?
Select TextBox1.
Click on Format + Conditional Formatting
For Condition1 select
Field Value Is
Greater Than
[TextBox2]

Select the backcolor.
Click OK
Click to expand...
 
Top