Date issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sc - 21 Mar 2005 09:49 GMT

I have a date field and want to set the field format like "__/__/05", so
that the user does not need to type the year each time.

Thank you for your help.

Best regards,

SC

Reply to this Message

Allen Browne - 21 Mar 2005 09:53 GMT

Do not use an input mask.

Then the user can just enter 3 or 4 keystrokes, e.g.
3/21
and Access will default to this year.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a date field and want to set the field format like "__/__/05", so
> that the user does not need to type the year each time.
[quoted text clipped - 4 lines]
>
> SC

Reply to this Message