mmddyy Format Probelm

[jutlaux]

I am wanting a user input a date as mmddyy onto a form. So in my table
design I set the field up to have a format of mmddyy. To do a quick test and
make sure it worked I just went into the datasheet view of my table and typed
in the number 042008, but I get and error

"The value you entered isn't valid for this field.

For example, you may have entered text in a numeric field or a number that
is larger than the FieldSize setting permits."

If i type in 04/20/08 it accepts it and then converts it to 042008. What am
I missing so that the user can type in the date as mmddyy when I go and
create a form.

 

[Maurice]

The way you type it access will see it as a numerical value. Why not set a
input mask in the table fieldproperties of the field. Could be something
like: 00/00/0000
That way the users don't have to type in the dashes and you'll get the
output you want.

hth