Calendar - Date and Time Picker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Martinez - 04 Aug 2005 03:18 GMT

Hello,

I am using Access 2002 I have limited space in my form so The Date & Time
picker is a great feature, but I do have nulls in my date field. My users
seems to have a problem with the check box in The Date & Time picker to
indicate it's a null. They don't know if they should click on it or not to
confusing for them. Is there a way I can have a null without placing a
check mark on the The Date & Time picker. I don't want to see the check box
at all. Is there a better solution. Thank you in advance.

Reply to this Message

Allen Browne - 04 Aug 2005 04:37 GMT

Yes, the DT Picker is a confusing interface.

The simplest solution is to use a little unbound Access form as a calendar.
There's heaps of free ones around, such as this one:
http://allenbrowne.com/ser-51.html

That article also links to Stephen Leban's wrapper class if you want
something more involved.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I am using Access 2002 I have limited space in my form so The Date & Time
> picker is a great feature, but I do have nulls in my date field. My users
[quoted text clipped - 3 lines]
> check mark on the The Date & Time picker. I don't want to see the check
> box at all. Is there a better solution. Thank you in advance.

Reply to this Message