Conditional Formatting dates

[rscott1989]

I am trying to get my expiration date field to highlight a certain color once the date comes closer.

I have weapons qualification dates. The user will input the date he/she qualified and then a expiration date (6 months from that day) automatically pops up.

Now what I want to do is once the expiration dates gets closer is change the color. So when it is 90 days from expiration it would highlight yellow, and when its 30 days away it would highlight red.

I believe this can all be done through conditional formatting, but for the life of me I cant figure it out!!

Any help is welcomed!!!!!

 

[jdraw]

Where exactly are you trying to do this?

 

[rscott1989]

im using access 2010. Im using it in one of my forms. I am attaching a pic.

 

[pr2-eugin]

What have you done so far? Is there any error associated with trying this way? What controls are involved?

Just for your information, a well documented tutorial/article provided by MSDN : http://msdn.microsoft.com/en-us/library/gg508986(v=office.14).aspx

With limited information as such you have provided, it might be hard to decipher the issue..

 

[rscott1989]

Sorry i am still learning this. I am not getting an error when i use the conditional formatting, I dont get anything. Thats why i think im just not inputting it correctly is there a way to use VBA insted? (Which im still not too savvy on)

something like

If expiration date > 90 - start_date
change color to XXXX

Does that make any sense? or am i completely missing it??? Im sure there is a certain code or something to make this easier, just not sure what it is yet haha.

Thanks for your patience!

 

[pr2-eugin]

Sure VBA can be used to do this.. You need to make use of the Form Current method.. BUT Before going there, check out the link I posted in Post#4..