Unbound Text Box & Access Calendar

W

wilderfan

Registered User.
Local time
Today, 00:38
Joined
Mar 3, 2008
Messages
172
It seems a lot of people are using calendars other than the built-in calendar (Access 2007).

QUESTION: Is it possible to get the Access calendar to pop up automatically when entering an unbound text box?

I can get the little calendar icon to show up, but I need to click on it to get it to expand.

Thanks in advance for any advice.


Cheers
 
yes, just set the format of the text box to DATE (Short Date, Long Date, whichever you need).
 
Did that.

The little calendar icon shows up when the focus switches to the unbound text box, but I'm wondering if I can get that icon to open up without having to click on it. That is, on entering the text box, I'd like to see the days of the current month rather than that little calendar icon.

Perhaps I need to write some VBA code?
 
Last edited:
Nope, if you use the built-in calendar you have to click on it. That is just the way it works.
 
That's too bad.

Oh well. One extra click won't kill anyone !
 
wilderfan said:
It seems a lot of people are using calendars other than the built-in calendar (Access 2007).

QUESTION: Is it possible to get the Access calendar to pop up automatically when entering an unbound text box?

I can get the little calendar icon to show up, but I need to click on it to get it to expand.

Thanks in advance for any advice.


Cheers
Click to expand...

Hi wilderfan,

If you were to use a third party calendar such as Allen Browne's popup calendar you could trigger the "On Got Focus" event on your unbound textbox or on the Icon button to display your popup calendar. I just tried it so I know it works.

http://allenbrowne.com/ser-51.html
 
Hi,

QUESTION: Is it possible to get the Access calendar to pop up automatically when entering an unbound text box?

I can get the little calendar icon to show up, but I need to click on it to get it to expand.
Click to expand...

Sure, you can easily do that in Access 2007. Add this one line of VBA code to the control's On Got Focus event:

DoCmd.RunCommand acCmdShowDatePicker

When you tab into or click into the control, the built-in date picker will display.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 
AccessJunkie said:
Sure, you can easily do that in Access 2007. Add this one line of VBA code to the control's On Got Focus event:

DoCmd.RunCommand acCmdShowDatePicker

When you tab into or click into the control, the built-in date picker will display.
Click to expand...
Oh, thanks for the info Jeff. I hadn't experienced that command yet. Will keep that one filed away for the future. I guess I need to go re-examine what commands are there now. :D
 
You must log in or register to reply here.

Similar threads

E
Dlookup on unbound text
Replies
10
Views
233
GPGeorge
GPGeorge
B
Listbox with just 3 or 4 items I would like to easily add/remove & saved. ValueList would be nice, perhaps avoid tables & subforms?
Replies
11
Views
367
GPGeorge
GPGeorge
P
Solved Odd Behavior in a form
Replies
7
Views
493
pdesantis8791
P
H
Solved Combo Box will only work if Access is not minimized
Replies
10
Views
173
Mike Krailo
Mike Krailo
D
Calendar displaying autonumber from a combo box..
Replies
5
Views
296
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom