[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Mask Edit Box / Date Validation

Posted on 1998-12-30
3
Medium Priority
?
356 Views
Last Modified: 2012-06-27
I'm using a maskEdBox with a format of dd-mmm-yyyy and a
mask of ##/##/####. It works fairly fine if I
enter something like "30121998", but if I enter just "30131998" and tab off the control it doesnt check if a valid date has been entered. Is there a switch I can set to force this validation or do I have to write a little checkroutine and call it in the LostFocus of the MEDBox.
0
Comment
Question by:eryan
  • 2
3 Comments
 
LVL 3

Expert Comment

by:vmano
ID: 1453286
ya, i think you have to write a date validation in the lostfocus of that MEDBox. you can probably use IsDate function to check for valid dates. also check for help on IsDate function.

let me know if this helps
vmano

0
 

Author Comment

by:eryan
ID: 1453287
IsDate is perfect. Return me your comment as a suggested solution and I'll forward you the points. Thanks.
0
 
LVL 3

Accepted Solution

by:
vmano earned 200 total points
ID: 1453288
OK.here is (my) same comment as answer.
i think you have to write a date validation in the lostfocus of that MEDBox. you can probably use IsDate function to check for valid dates. also check for help on IsDate function.

let me know if this helps
vmano
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

872 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