Display in form

F

Freehal04

Here's a simple question. I have a field in my form that displays a the
amount of time (in days) till something is due. It displays negative numbers
for things that are passed its due date. I was wondering how can I display
the negative numbers in red, so they are more easily visable? Thanks.
 
K

Klatuu

You can use conditional formatting to cause the text to display red if the
value is less than 0.
 
K

Klatuu

There are no commands to input.
Open your form in design view.
Select the control you want to format.
From the menu, select Foramt, Conditional Formatting
You will get a dialog box that is pretty easy to follow from there.
 
Top