Force use of Calendar

[QB]

How can I force a user to use a calendar to select dates (double-click) and
not allow manual entries in a given text box?

I tried to lock the control but then it does not accept values from the
calendar either.

Thank you,

QB

 

[jubiiab via AccessMonster.com]

Why would you do that? If you have the field value as Date/Time in your
database table you should not worry. It will only accept the right entry.
Like 19-09-2009. Instead you should spend some time to introduce your users
to your system and tell them about the option to double click or enter
manually.

 

[QB]

There are a number of reasons, such as :

*Data standardization - Formatting and Entry Errors (is it m/d/y, d/m/y or
y/m/d,....)
*Data entry speed
*And more

beyond which, I have code that gets executed when the calendar is used and
not when manual entry is done. Considering the number of date fields, I
really would like to avoid created After_Change events for all, thus the
question.

 

[Linq Adams via AccessMonster.com]

Sorry, jubiiab, but that's simply not true! "The value you entered is not
valid for this field" doesn't really do much for guiding the user to enter a
correct value!

And

1/12/2009

and

12/1/2009

are both valid dates, but they can either stand for the same day of the year,
or for days that are over 10 months apart. It is usually very important to
have dates entered excatly as they should be, and a calendar, whether ActiveX
or a custom hack, is the best way to do this!

QB, I think you should go back and check on this. Locking a textbox should
not keep you from populating it via code, as you would using a calendar. You
might want to check to make sure that the form itself can be edited. It could
be read-only, if it's based on a multi-table query, or if you have AllowEdits
and/or AllowAdditions set to No.

 

[Linq Adams via AccessMonster.com]

QB, could we see the code you're trying to use to assign the calendar
selection to the textbox?

 

[QB]

Thank you. I will check out my form properties and get back to you.
QB