Can someone please help me out with date formatting. I have a few different
fields that have different date formats. Some are yy/mm/dd and some are
mm/dd/yy. Regardless of what I put in the properties for a format or what I put
for an Input Mask, Access still allows invalid dates (and values that are not
even dates) to be entered into this field. Does anyone know a good way to ensure
that the proper date format is entered?  Thanks in advance for your help.

Joe

To ensure you only get the format you want..  make sure the
input mask and the format are set in the table design view
correctly..  and if you are using a form based off of that
table, make sure the format and input mask of the date fields
on the form match the tables format and input mask.


later,
bware

-----Original Message-----
From: jbird@a... [mailto:jbird@a...]
Sent: Tuesday, January 21, 2003 8:56 AM
To: Access
Subject: [access] Date Formatting




Can someone please help me out with date formatting. I have a few different
fields that have different date formats. Some are yy/mm/dd and some are
mm/dd/yy. Regardless of what I put in the properties for a format or what I
put
for an Input Mask, Access still allows invalid dates (and values that are
not
even dates) to be entered into this field. Does anyone know a good way to
ensure
that the proper date format is entered?  Thanks in advance for your help.

Joe

Hello,

This prob may not be anything to do with Access, try this.

1, Open Control Panel.
2, Open Regional Settings/Options.
3, Select the time & date tab.
4, Change the time/date into the desired format. eg: dd/mm/yy

N.B. Yon may have to recreate your time and date fields.

Please inform me if this has worked.

Kind Regards,

-----Original Message-----
From: jbird@a... [mailto:jbird@a...]
Sent: 21 January 2003 15:56
To: Access
Subject: [access] Date Formatting




Can someone please help me out with date formatting. I have a few different
fields that have different date formats. Some are yy/mm/dd and some are
mm/dd/yy. Regardless of what I put in the properties for a format or what I
put
for an Input Mask, Access still allows invalid dates (and values that are
not
even dates) to be entered into this field. Does anyone know a good way to
ensure
that the proper date format is entered?  Thanks in advance for your help.

Joe