Masked Edit Control date type problem

Masked Edit Control date type problem

Post by Robert Mull » Mon, 12 Jan 1998 04:00:00

I am in the process of converting an Access 7 database into a VB5
application. Nearly everything has been straightforward but I am
having a problem with the Microsoft Masked Edit Control and the format
that Access uses for dates. I have tried many different things but
Access seems to be able to strip away leading 0s and such and this is
playing havoc with data storage and retrieval. Has anyone run into
this type of problem before? One thing that seems to be happening is
the possibility that dates are being converted by one of the elements
into a Julian date and then that numeric value is being taken as a
literal date by the other element. I have tried many masks and tried
CDate() but the only thing that has worked so far is to change the
field data type to text and then store the prompt as well. This is a
very undesirable solution that has the side effect of not clearing the
edit control if the next value is missing. The previous value stays
put. Any suggestions? I am limited to the Professional Edition where I
am doing this so Sheridan controls are not an option. Feel free to
respond via e-mail or post. Thank you.


1. problems with Mask edit controls bound to data controls

To control user's input, I would like use Mask edit.
On my form I have a button, to add a new record, but when VB execute
I have a validation error and after a run-time error, with the empty
field (His mask is ?######), and I can't resume this error.

Somebody has an idea where i'm mistaking (i think it's possible to
add a new records with this control.

        Thank Your for your help

        Arnaud - France - Paris

2. How to use Update trigger on same table?

3. Masked Edit Control and Remote data control problem

4. Need a Type 4 JDBC Driver

5. Date fields an Mask Edit control

6. date time conversion problem

7. Problem with Masked Edit Control 6.0

8. Filepro upgrade

9. Problems with the Masked Edit control in VB4.0

10. masked Edit Control Problem

11. Masked Edit Control /AddNew Problem

12. Masked Edit Control Problem

13. Problem with bound DataCombo and Masked Edit controls when changing their contents