If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Input Masks
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 |
#2
|
|||
|
|||
Just an observation:
What will you do when the year is 2006? Create a new db? "Bob Griendling" wrote in message ... 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 |
#3
|
|||
|
|||
On Fri, 10 Jun 2005 12:11:49 -0400, "Bob Griendling"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i make a cell date sensitive to execute a formula or input. | ebuzz13 | General Discussion | 2 | January 20th, 2005 08:33 PM |
Input Masks | mk2 | Database Design | 1 | October 31st, 2004 08:52 PM |
Input masks not being displayed | jfischer_5809 | General Discussion | 1 | September 8th, 2004 05:41 PM |
Excel date masks | Duncan Findlay | Worksheet Functions | 2 | August 23rd, 2004 12:41 PM |
more dates!!! | brigid | Running & Setting Up Queries | 6 | May 26th, 2004 10:59 AM |