ceate date in form using input mask

[Guest]

l failed to ceate date using input mask .
For detail;
Description: mm/dd/yyyy
Input mask;00/00/0000
place holder;/
sample date;23/03/2006

Any help would be appreciated.Thanks

 

[Guest]

Hi Zila

You don't really need an input mask for this. Set the format as Short Date
and access will do the rest.

If you do want to use a mask use 00/00/0000;0;_

Hope this helps

 

[Douglas J. Steele]

You're listing the description as mm/dd/yyyy, yet your sample date is
23/03/2006.

Which are you really trying to use, and what has your short date format been
set to through Regional Settings?

 

[Guest]

In my country we used 23/6/2006 not 6/23/2006. How to change it.
Thanks for your help.

 

[Guest]

l'm using short date . l want to know is it any way that when l type
12/04/2006 the result is 12-apr-2006 not 4-apr-2006

 

[Guest]

this only happened to month april and december

Hi Zila

You don't really need an input mask for this. Set the format as Short Date
and access will do the rest.

If you do want to use a mask use 00/00/0000;0;_

Hope this helps

 

[Joan Wild]

You are better off not using an input mask at all. That just restricts the
user too much. Also you assume that everyone's Regional Settings are set
the same, and they may not be.

A user can simply enter 24/7 or 7/24 (depending on their RS) and Access
will assume the current year. With an input mask, you'll force them to
enter more digits than necessary.

A good idea though, is to set a format on the textbox - dd/mmm/yyyy

This will only affect the *display* of the date, not how it's entered. The
user will see right away if Access misinterpreted their entry - note the
extra m for the month, to display three char - i.e. 24/Jul/2006

 

[Guest]

thank you .l tried to create list box , maybe l have never using it before,
can you or anyone can help me.

 

[Joan Wild]

Why a list box? I thought you were trying to set an input mask? Set the
format property instead.

 

[Guest]

thanks joan. l used medium date and its ok

Why a list box? I thought you were trying to set an input mask? Set the
format property instead.