Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top