Table Issues

[Syd]

I have a major problem with the "Date" field in table, the
field name is called "dtedate". I have the date field set
to "General Date" format. The table default value is
blank. The form's control feeding that field a set to
display a MM/DD/YYYY format. However, when any data is
entered I get a short date plugged into the table as a
value. Is there a problem of corruption playing into this
picture, or simply a formating issue?

Any suggestions will apprciated about now. I'v been
fighting with this thing for about an hour or more now.

If I need to change the fields name due to corruption, is
there a simple method I can use to change the refernce
everywhere it's called in one pass?

Thanks,

 

[Van T. Dinh]

Format Property of the Control only affect how the date is displayed, NOT
how it is entered. If you want to insist the users to use a particular
format for data entry, you need to set the InputMask Property of the
Control.

Check Access / Access VB Help on the InputMask Property.