Different Text Color for Different Value

[Lee Mathews]

I am a Access Designer, among other things, I
seem to be having a problem, with changing
text color. In a column, I want to say see if a series of numbers falls within the boundries. Say for example; Low point will
be 2.50 and High point will be 4.00. If the numbers stay within this range I want the color to be black. If these numbers are higher or lower than the established range, I want them to be red, showing as out of spec.

 

[AlaskanDad]

In the control source for the text box try this:

= Iif([NumberBox]<[LowPointBox] OR [NumberBox]>[HighPointBox],Format([NumberBox],[Red]),[NumberBox])

Let me know if this helps.

 

[Mitch]

Try putting the following in the OnCurrent() Procedure of the form.

If [txtYourText] < 2.50 then
[txtYourText].Forecolor = 255
Elseif [txtYourText] > 4 then
[txtYourText].ForeColor = 255
else
[txtYourText].ForeColor = 0
end if

Please note this will only work if you are using a text box in a continuous form instead of a list box as you cannot control the individual colours of each row/column in a list box, only that of the list box as a whole.

HTH

Mitch.

 

[Lee Mathews]

Thank you very much Mitch. It worked.

If there is any help, I can be please do not
hesitate to ask