mmddyy Format Probelm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jutlaux - 21 Apr 2008 16:52 GMT

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.

Reply to this Message

Maurice - 21 Apr 2008 18:21 GMT

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

Signature

Maurice Ausum

> 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
[quoted text clipped - 9 lines]
> I missing so that the user can type in the date as mmddyy when I go and
> create a form.

Reply to this Message