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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
referring to texbox 4
SetFocus problem 7
Textbox1 color 1
conditional formatting in a Report 1
Issue in conditional formatting 2
Calculate Form Fields 6
Format Question 1

Back
Top