Text box font color determined by value

[Dale]

I have a form that has the default view set to continuous forms.
Within each record are three text boxes that display numeric values
for three different fields. I was wondering if it is possible to
change the font color or back color of the text box that has the
greatest value of the three text boxes within each record. I've tried
setting up IF statements within the after update event for each text
box and this does not work. I am just looking for a way to make it
very easy to scan the form and have the greatest value for each record
stand out. Any ideas would be appreciated.

 

[Wayne Morgan]

If you're using Access 2000 or newer, in design view right click the textbox
and choose Conditional Formatting. Place your equation in here and set the
properties you want.