Special Date Input Settings

[JHB]

Hi:

I am attempting to make the entry of a date as easy as possible for an
administrator. I have dates which are mostly (but not always) in the
current year. I would like the administrator to be able to enter MM/DD
and have Access slip in the current year so that the final format
stored is MM/DD/YYYY. If that is not possible, is there some way to at
least make the century automatic so that only the 12 of 2012 is
required.. In all cases we would want to be able to override what the
system created. because situations will arise where it will create the
wrong entry.

I have tried various combinations of settings and none appears to do
the trick.

Does anyone have any suggestions?

Best

John Baker

 

[John W. Vinson]

Hi:

I am attempting to make the entry of a date as easy as possible for an
administrator. I have dates which are mostly (but not always) in the
current year. I would like the administrator to be able to enter MM/DD
and have Access slip in the current year so that the final format
stored is MM/DD/YYYY. If that is not possible, is there some way to at
least make the century automatic so that only the 12 of 2012 is
required.. In all cases we would want to be able to override what the
system created. because situations will arise where it will create the
wrong entry.

I have tried various combinations of settings and none appears to do
the trick.

Does anyone have any suggestions?

Best

John Baker

Ummm...

Access already does this, with no code at all.

Just be sure there's no Input Mask on the form textbox. Typing

3/16

will insert #03/16/2012 00:00:00# into the Date/Time field, and it will be
displayed in accord with whatever format you've defined on the field or the
form control.

Note that a Date/Time field is actually stored as a Double Float number, a
count of days and fractions of a day (times) since an arbitrary start point
(12/30/1899 if it matters). The Format controls how that number is displayed
but has no effect on what's stored.

My guess is that you have an Input Mask such as 00/00/0000 defined for the
field; this will force typing all eight digits. Lose the mask and you'll lose
the problem!
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[JHB]

Ummm...

Access already does this, with no code at all.

Just be sure there's no Input Mask on the form textbox. Typing

3/16

will insert #03/16/2012 00:00:00# into the Date/Time field, and it will be
displayed in accord with whatever format you've defined on the field or the
form control.

Note that a Date/Time field is actually stored as a Double Float number, a
count of days and fractions of a day (times) since an arbitrary start point
(12/30/1899 if it matters). The Format controls how that number is displayed
but has no effect on what's stored.

My guess is that you have an Input Mask such as 00/00/0000 defined for the
field; this will force typing all eight digits. Lose the mask and you'll lose
the problem!
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thanks..your dead right!!