Date Input Masks

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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top