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

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" wrote:

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

THANKS WAYNE!

"Wayne-I-M" wrote:

> 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" wrote:
>
> > 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
> >