Red lettering on a form

[rwilson32]

I was hoping someone would know a way to change a text box's font color in VB Code. Now I know how to change 1, but my form is continuous with several text boxes containing a date and I want to change only the overdue ones to red. In design view it is just one box but in form view it is numerous ones and I want to know how to change just a few of them. thank you

 

[Mark Wild]

Try pasting this into the format of the control

#,##0;(#,##0)[Red];;"Null"

Set your own comma, decimal formats etc. The order is positive numbers, negative numbers, zeros and nulls.

HTH

 

[evilman]

you can change the colors in vba like this:
SomeControle.ForeColor = vbred