Changing Text colour on value amount

[stu_C]

Hi all


I have a form with different number values, is it possible the when a value gets under a certain number the text colour in that field can change?

so for instance
if the text field MilageLeft goes under 1000 it changes to red?

[ketbdnetbp]

Depending on the type of form you are using and your application, you might be able to use conditional formatting or VBA to accomplish your goal. Check out the Conditional Formatting options in the format menu. If VBA, the same code would be used in the Current Event of the form as well as the AfterUpdate event of a control(s) that triggers a re-calculation of the MilageLeft field. Something like...

If Me.MilageLeft < 1000 then
Me.MilageLeft.ForeColor = 255
else
Me.MilageLeft.ForeColor = 0
end if

Hope this helps,

Jim