Desired control behind another

[Wes from Scottsdale]

I have a calendar control that is set to become visible when a button is
clicked. Unfortunately, part of it is coming up behind another list box.
How do I set the layer of a control. Is there any option like Visio's Bring
To Front command?

 

[Dirk Goldgar]

I have a calendar control that is set to become visible when a button is
clicked. Unfortunately, part of it is coming up behind another list box.
How do I set the layer of a control. Is there any option like Visio's
Bring
To Front command?

There is a BringToFront command in the form designer, but in my experience,
list boxes always want to be in front. You can try selecting the calendar
control in form design view, then clicking Format -> Bring to front (or the
equivalent in Access 2007), but I don't know if that will work. If it
doesn't, you may have to reposition the control, or maybe set the list box
to be invisible when you show the calendar.

 

[Wes from Scottsdale]

Unfortunately, the list box spans the majority of the form whereas the
calendar only covers about 10%. I think it will be too distracting to the
user to have the listbox visibly changing states when they are selecting
dates.

For now I've moved my calendar a bit, but had to extend the size of my form
to add space for the calendar to show.

I would have expected MS tol fix the listbox domination problem. Is this an
issue in 2007 as well?

 

[Dirk Goldgar]

Unfortunately, the list box spans the majority of the form whereas the
calendar only covers about 10%. I think it will be too distracting to the
user to have the listbox visibly changing states when they are selecting
dates.

For now I've moved my calendar a bit, but had to extend the size of my
form
to add space for the calendar to show.

I would have expected MS tol fix the listbox domination problem. Is this
an
issue in 2007 as well?

I don't know. Access 2007 has a built-in calendar control, for what it's
worth.

Steve's suggestion of putting the calendar control on a small popup form
sounds good to me. Or use Stephen Lebans' API-generated calendar:

http://www.lebans.com/monthcalendar.htm