Table Issues

  • Thread starter Thread starter Syd
  • Start date Start date
S

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,
 
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.
 
Back
Top