mask edited ???

Posted on 1998-09-23
Last Modified: 2010-04-30
Dear Experts,
      I faced a problem in using the maskedited for Date.
When I key in the date like :) 08/15/1998, the maskedited will automatically convert to 15/081998.. although I have already formated my date into dd/mm/yyyy... How can I solve this problem ?  This type of automatically converting problems also happened when  I try to key in the date like:)

15/08/0020 ----> 15/08/2020 etc.

How can I detect it and not allow this type of convertion
occurs ???

Question by:SWP

Expert Comment

ID: 1436364
May I know what do you expect when you enter 08/15/1998? I thought since you have set the format to be dd/mm/yyyy, the converted result 15/08/1998 is correct...

LVL 15

Expert Comment

ID: 1436365
what is your mask and format strings?

Accepted Solution

trkcorp earned 80 total points
ID: 1436366
Go to regional settings on the control panel and check your date formats.

Expert Comment

ID: 1436367
TRKCORP is correct. What you are looking for is European sytle Date settings.  These settings use dd/mm/yyyy vise U.S settings mm/dd/yyyy.  Just go to Regional setting in Your control pannel to change.  If that isnt what you want then call me.


Author Comment

ID: 1436368
Sunj is correct. I had set the format of date to dd/mm/yyyy, so VB straight away convert the incorrect date to the correct format. thank you for yours answers.


Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA to copy paste columns form one file to other 20 91
Reading the Contents of a Directory In Access VBA 5 77
vbModal 12 57
adding "ungroup sheets" to existing vbs code 5 31
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question