Date Format

[Irfan Salim]

In a table in Access Database, I have defined a field with datatype Date/Time.

What I want is to take input on a form for this field using a text box.

I want user to enter the date in the Format 10-Dec-2002 and store this date in table as 10/12/2002.

 

[indesisiv]

Set the format of the date field to dd/mm/yyyy
And set the input mask to something like 99\->L<LL\-0000;0;_
that should do what you want


Steve