conditional formatting

[jonamua1971]

i have been searching on this forum on conditional formatting but i can seem to get my problem solved.
i have due dates that i would like to change colors when they are 15 days before due date and red for 30. i have tried some examples but they are all not working.
expr DATE()+15= (red font)
Any help will be highly appreciated.

 

[Scooterbug]

To change the font color on a form, it would be:

me!Control.forecolor = 255

255 = red. To find other colors, you can go into the properties of a control, select Fore Color and select the color from the pallet. It will fill in the number for that color.

 

[MSAccessRookie]

i have been searching on this forum on conditional formatting but i can seem to get my problem solved.
i have due dates that i would like to change colors when they are 15 days before due date and red for 30. i have tried some examples but they are all not working.
expr DATE()+15= (red font)
Any help will be highly appreciated.

I believe that Standard Conditional Formatting can work for you and that Special code will not be required.

• Right Click on the Field.
• Choose "Conditional Formatting" from the resulting Menu.
• Fill in the Conditions (including the color choices)

This will allow you to enter as many conditions as are required. You seem to need 3 (Normal, 15-30 days, and 30+ days)