Calendar Control Always On Top

[Chris1112]

I am using the built-in Calendar Control 12.0 with Access 2007. I have placed rectangles on the form over the calendar but the calendar seems to always be on top of them. I have brought them to the front, sent the calendar to the back, and they are still not there. I have verified that they are visible by moving the calendar control and checking form view.

Any suggestions on how to make these sit on top of the calendar?

Thanks in advance.

 

[boblarson]

Any suggestions on how to make these sit on top of the calendar?

Nope, controls can't sit on top of them (just like subforms can't have controls on top of them either).

 

[missinglinq]

I don't run 2007, but in previous versions their are some objects Access will not let you place other objects in front of; ActiveX calendars are such objects, as are Listboxes. Trying to place a textbox in front of a Combobox, once, at a poster's request, repeatedly caused Access to close with the usual apology!

The thing all of these objects have in common, and the reason Access won't let you do it, I suspect, is that the primary purpose of these objects is to select data. The Access Gnomes apparently don't want you impeding this function!

 

[Chris1112]

I appreciate the responses. That is unfortunate to learn.

Could a custom calendar control allow me to do what I want? I don't want to develop one from scratch, but I do need to be able to show events on the calendar. I intended to make rectangles visible based on the days that events occurred. Seemed easy. I appreciate any suggestions.

 

[boblarson]

Try checking out the attachment on this thread. You may need to register on the site, if you aren't already, to download.

 

[Chris1112]

I'll need to modify it a bit, but that's far better than creating it from scratch. Thanks a ton Bob!