ceate date in form using input mask

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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?
 
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
 
this only happened to month april and december

Wayne-I-M said:
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
Click to expand...
 
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
 
thank you .l tried to create list box , maybe l have never using it before,
can you or anyone can help me.
 
Why a list box? I thought you were trying to set an input mask? Set the
format property instead.
 
Back
Top