Article View: comp.databases.ms-access
Article #227Re: newbie question I - Date fields / input mask & regional settings
From: Birthe Weidinger
Date: Thu, 31 May 2001 08:02
Date: Thu, 31 May 2001 08:02
23 lines
1991 bytes
1991 bytes
Try to set the fields format to the format you want ex. dd-mm-yy (shown as 31-05-01) Birthe. "Henning Lang" <hlang@myrealbox.com> skrev i en meddelelse news:e6pP6.1$rB3.244@news010.worldonline.dk... > In all my tables and forms I've defined my date fields with a input mask of > 00 in the year fields. This works out fine except in one situation. On the > pc's where the application is to be used, the regional settings are defined > as yyyy as the year and therefore the "output" on the forms get showns as > yyyy. The problem is that when a user edits one of the date fields and > changes the month field they will also have to change the 2001 year to 01 to > make it obey the input mask. Is there any workaround to this problem. > > > Henning Lang > hlang@myrealbox.com > >
Technical Details
Message-ID:
<9f4tn4$fvb$1@news.inet.tele.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!news.tele.dk!TDC-Europe.POSTED!193.89.229.143!not-for-mailReferences:
<e6pP6.1$rB3.244@news010.worldonline.dk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff0ac,f78daa5b0298dc2f X-Google-Attributes: gidff0ac,public X-Google-Thread: 11387c,f78daa5b0298dc2f X-Google-Attributes: gid11387c,public X-Google-ArrivalTime: 2001-05-31 01:00:37 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!news.tele.dk!TDC-Europe.POSTED!193.89.229.143!not-for-mail From: "Birthe Weidinger" <birthe@unibase.dk> Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access Subject: Re: newbie question I - Date fields / input mask & regional settings Date: Thu, 31 May 2001 10:02:03 +0200 Organization: Posted through some European Outpost of TDC Internet A/S Lines: 25 Message-ID: <9f4tn4$fvb$1@news.inet.tele.dk> References: <e6pP6.1$rB3.244@news010.worldonline.dk> NNTP-Posting-Host: 193.89.229.143 X-Trace: news.inet.tele.dk 991296036 16363 193.89.229.143 X-Complaints-To: the appropriate department of the poster's provider X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700