Question with Color Conditioning in Access

[ekeenan81]

Is it possible for me on a form to condition the field to be certain colors depending on the date difference?

Ex. Days to Expiry

The initial formula to derive date is straightforward

TODAY()-ExpirationDate(Table Attribute)

Would it be possible to also condition this field to be certain colors, so when Days to Expiration are say 30 days, it highlights date in RED, when 30 to 60 Days Yellow, and so on etc....

I am thinking this would be some VB Coding possibly with some conditional if statements?


Any help or pointers in the right direction would be helpful.

Thanks

 

[SydneyGeek]

If you have Access 2002 or higher you can use conditional formatting, and it's very similar to the conditional formatting in Excel.
In the form's design view, right-click the text box for the field that you want to format. You should see Conditional Formatting on the list. Otherwise, look in the menus.

Denis

 

[ekeenan81]

Thanks Denis.. I will give it a whirl tonight.