Date Input Masks

  • Thread starter Thread starter Bob Griendling
  • Start date Start date
B

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
 
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.
Click to expand...

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]
 
Back
Top