How to enlarge Date Picker?

  • Thread starter Thread starter Birgit via AccessMonster.com
  • Start date Start date
B

Birgit via AccessMonster.com

It would be very handy if the Date Picker in Acces 2007 could be enlarged on
the event "On Enter". How it should be done? Is it possible?
 
It would be very handy if the Date Picker in Acces 2007 could be enlarged on
the event "On Enter". How it should be done? Is it possible?
Click to expand...

I have the feeling the answer is no but I'd be fascinated if one of
the gurus knew of a clever way to do this. I had exactly the same
question earlier this week.

-- James
 
I suspect James is right. The workaround, I think, would be to place a
command button with a calendar image on the form, have the DP invisible, and
in the OnClick event of the button make the DP visible.

What I do for this type of thing is place a DatePicker control on the form,
positioned as you like and set it's Visible Property to NO.

Then, using the DoubleClick property of your text box, have the DatePicker
"popup" for date selection. You'll need to replace YourDatePickerName and
YourTextBoxName with the actual names of your DatePicker and text box.

Private Sub YourTextBoxName_DblClick(Cancel As Integer)
YourDatePickerName.Visible = True
End Sub

Private Sub Form_Load()
YourDatePickerName.Value = Date
End Sub

Private Sub YourDatePickerName_Click()
YourTextBoxName.Value = YourDatePickerName.Value
YourTextBoxName.SetFocus
YourDatePickerName.Visible = False
End Sub

Now, all your user has to do is DoubleClick on the text box and up pops the
DatePicker! When the user clicks on the date, the DatePicker disappears and
the text box is populated with the date.

Linq

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Back
Top