Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Date format -medium date input mask-French Canadian

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BillD - 12 Jul 2007 22:54 GMT
I created a database and set the table date fields to Medium date and
included an input mask for the medium date  99\->L<LL\-00;0;_  I created the
database on a computer that uses English settings. I installed the database
on a computer that must have french settings. The input mask will not work.
What is the input mask for medium date in french. I know that the french have
3 and sometimes 4 letters for medium dates. Ex. January 14, 2007 is
14-Jan-07. June 14, 2007 is 14-Juin-07.
What would be the proper input mask?
Joan Wild - 13 Jul 2007 15:02 GMT
Bill, you will find things much easier if you don't use an input mask for a date at all.  Access will interpret the user's entry based on the Regional Settings on their computer.  See Allen Browne's site for working with dates:
 http://www.allenbrowne.com/ser-36.html

Signature

Joan Wild
Microsoft Access MVP

>I created a database and set the table date fields to Medium date and
> included an input mask for the medium date  99\->L<LL\-00;0;_  I created the
[quoted text clipped - 4 lines]
> 14-Jan-07. June 14, 2007 is 14-Juin-07.
> What would be the proper input mask?
BillD - 14 Jul 2007 05:16 GMT
This sounds good. The only problem is how do you know what to input if there
is no mask?

> Bill, you will find things much easier if you don't use an input mask for a date at all.  Access will interpret the user's entry based on the Regional Settings on their computer.  See Allen Browne's site for working with dates:
>   http://www.allenbrowne.com/ser-36.html
[quoted text clipped - 7 lines]
> > 14-Jan-07. June 14, 2007 is 14-Juin-07.
> > What would be the proper input mask?
BillD - 14 Jul 2007 15:32 GMT
Joan:
I have found that the short date is an excellent format. If I use
00/00/0000;0;_ as an input mask do you see an inherent problems with this. By
using an input mask, the form of the data is apparent to the person
inputting. This helps when you have constantly new people inputting.

Thanks Again for your help.
Bill Depow- Fredericton, NB

> Bill, you will find things much easier if you don't use an input mask for a date at all.  Access will interpret the user's entry based on the Regional Settings on their computer.  See Allen Browne's site for working with dates:
>   http://www.allenbrowne.com/ser-36.html
[quoted text clipped - 7 lines]
> > 14-Jan-07. June 14, 2007 is 14-Juin-07.
> > What would be the proper input mask?
Joan Wild - 14 Jul 2007 16:06 GMT
Yes I do see a problem.  You can force the person to enter 10/07/2007, but is that Oct 7 or July 10?  Although Canada has a standard date format, few actually adhere to it.  I've seen a good deal of mix in Regional Settings - some are set to dd/mm/yyyy and just as many to mm/dd/yyyy.

So their entry of 10/07/2007 will be interpreted by Access according to the Regional Settings on the computer.  The user might not be aware of their settings and intend something different.  To further muck things up, Access will spin a date around if it doesn't conform to the Regional Settings until it does get a valid date - i.e. Regional Settings set to mm/dd/yyyy and the user enters 14/07/2007.  That's not a possible date for the RS, so Access spins it to 07/14/2007 or possibly 07/07/2014.  Then you'll get users claiming that 'sometimes' Access gets the date wrong.

An input mask on a date field just slows people down.  You can enter 10/7 (or 7/10 if that's your RS) and Access will assume the current year.  If you force the input mask, you're asking them to enter 6 more keystrokes unnecessarily.  In addition, the input mask demands that they enter your 10 keystrokes.  Without the mask the user has the freedom to enter the date any way they wish...
Jul 7
July 7, 2007
7/7
7/7/7
7/7/2007
will all be accepted.  Even those who don't know the shortcuts in Access can still enter the date any way they wish.  Over time you can train users on the quick entry methods.

What you need to be concerned with is the fact that users may not know what their RS is set to; you want to be certain that Access interprets their entry correctly.  Set the format of the control to an unambiguous date format such as dd/mmm/yyyy or mmm/dd/yyyy.  That way the user will see right away whether the date was taken as they intended.

Signature

Joan Wild
Microsoft Access MVP

> Joan:
> I have found that the short date is an excellent format. If I use
[quoted text clipped - 16 lines]
>> > 14-Jan-07. June 14, 2007 is 14-Juin-07.
>> > What would be the proper input mask?
BillD - 15 Jul 2007 13:22 GMT
That was very good/informative.
Thankas again,
Bill Depow

> Yes I do see a problem.  You can force the person to enter 10/07/2007, but is that Oct 7 or July 10?  Although Canada has a standard date format, few actually adhere to it.  I've seen a good deal of mix in Regional Settings - some are set to dd/mm/yyyy and just as many to mm/dd/yyyy.
>
[quoted text clipped - 30 lines]
> >> > 14-Jan-07. June 14, 2007 is 14-Juin-07.
> >> > What would be the proper input mask?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.