Calendar Color

Using Access ’03…

I have an ActiveX calendar control on a form.

Is there a way to programmatically change the color of a day based on
a formula? E.g., if hours in a particular record (which contains a
date) exceed 10 then turn calendar day to a specific color?

Thanks,
alex

Only if the ActiveX control has the capability and then you would have to
know the method and parameters it requires.

There are several different Non ActiveX calendars you can find browsing
around the web. Choose one that includes the source code so you modify it to
your needs. In addition, you will be a lot better off not using ActiveX
controls. They are a pain in the A** and there is also the legal issue of
deploying them.
--
Dave Hargis, Microsoft Access MVP


"alex" wrote:

Using Access ’03…

I have an ActiveX calendar control on a form.

Is there a way to programmatically change the color of a day based on
a formula? E.g., if hours in a particular record (which contains a
date) exceed 10 then turn calendar day to a specific color?

Thanks,
alex

On Jul 2, 4:26*pm, Klatuu wrote:
Only if the ActiveX control has the capability and then you would have to
know the method and parameters it requires.

There are several different Non ActiveX calendars you can find browsing
around the web. *Choose one that includes the source code so you modify it to
your needs. *In addition, you will be a lot better off not using ActiveX
controls. *They are a pain in the A** and there is also the legal issue of
deploying them.
--
Dave Hargis, Microsoft Access MVP



"alex" wrote:
Using Access ’03…

I have an ActiveX calendar control on a form.

Is there a way to programmatically change the color of a day based on
a formula? *E.g., if hours in a particular record (which contains a
date) exceed 10 then turn calendar day to a specific color?

Thanks,
alex- Hide quoted text -

- Show quoted text -

Thanks for your help Dave.
alex