Date Input Masks

[Bob Griendling]

I have a date input mask of 99/99/"05";0;_

If I enter a date 0610 and hit tab, it fills in the correct "short date" of
6/10/2005.

However, if I copy a record and then try to paste it in a new data entry (so
as to not have to duplicate similar info., I get a message that "The value
you entered isn't appropriate for the input mask '99/99/"05;0_' specified
for this field."

I've used Access for years and have never rec'd this message when copying
and pasting in this way until last year. I can't figure out why.

If I copy only one record, it will paste the record anyway, after I hit OK.
But it won't when I paste two records.

Any suggestions?

Bob

 

[DL]

Just an observation:
What will you do when the year is 2006?
Create a new db?

 

[John Vinson]

I have a date input mask of 99/99/"05";0;_

If I enter a date 0610 and hit tab, it fills in the correct "short date" of
6/10/2005.

Try using a date mask of 99/99 - Access will fill in the current year
(whatever it is) automatically.

If you are going to copy and paste, the source must have the slash (or
it won't match the mask).

I'd be inclined not to use date masks at all, especially if you'll be
both typing and copy/pasting - they're more hassle than they're worth!

John W. Vinson[MVP]