conditional formatting expression

M

mccoy

i want my field to become red when its value is more than the half of the
other field
what expression is the right expression or code for this
 
W

Wayne-I-M

Hi

Rather than using code I would use conditional formating on the second control

Open the form in deisgn view.
I assume there are 2 controls (number format)
Select the 2nd control (the one you want to change colour)
Select format
Select Condidtional Formating
In the Dropdown select "Expression Is"
In the ccriteria in sert this [textA]>([TextB]/2)
Set the background Red

Change TextA and TextB to the names of the real controls
TextB - is the control that you want to turn red when it is more than 50% of
TextA

Hope this helps
 
M

mccoy

THANKS WAYNE!

Wayne-I-M said:
Hi

Rather than using code I would use conditional formating on the second control

Open the form in deisgn view.
I assume there are 2 controls (number format)
Select the 2nd control (the one you want to change colour)
Select format
Select Condidtional Formating
In the Dropdown select "Expression Is"
In the ccriteria in sert this [textA]>([TextB]/2)
Set the background Red

Change TextA and TextB to the names of the real controls
TextB - is the control that you want to turn red when it is more than 50% of
TextA

Hope this helps







--
Wayne
Manchester, England.



mccoy said:
i want my field to become red when its value is more than the half of the
other field
what expression is the right expression or code for this
Click to expand...
Click to expand...
 
Top