Form not big enough

[Sprocket]

I have a form with a subform.

The subform is quite a small area - and cannot be made any bigger

The subform has a date control on it.

I want to use the Active X Calendar control to select a date that will then be entered into this control.

I have the code side of thing sorted OK except when the calendar
pops up you can only see a small part of it - this is because it is on the sub-form which is in effect a small window in the main form.

What I really need is to get the calendar to pop up on the main form but then I can't set the data control source to the sub-form as the only controls that appear in the selection list are those on the main form

Is there any way to get round this??

 

[Fizzio]

A way around this is not to bind the calendar control to anything, bind the date field to the textbox. Place the calendar control on it's own unbound form and on the GotFocus / OnEnter properties of the textbox you want the date to go in, open the form

DoCmd.OpenForm "NameOfCalendarForm", , , , , acDialog

Have a look at the demo I have attatched. It used the On_Click properties of the textbox but I'm sure it can be modified for the above events.

HTH

 

[Sprocket]

Magic - It works brilliantly.

I like this idea of free standing forms - definately one to remember.

Thanks