Date Imput Mask Question

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I'm trying to figure out a way to imput the date as 9.12.03 and have it come
out as 9/12/03 on the form and table. Is this possible and
how...Thanks...Randy
 
Randy said:
I'm trying to figure out a way to imput the date as 9.12.03 and have it come
out as 9/12/03 on the form and table. Is this possible and
how...Thanks...Randy
Click to expand...

Formatting is independent of masking.

Why do you need the dots?

9 12 will give you 9/12/03 or September 12, 2003 if you wish.
the year only has to be added if it's not this year.
Granted there are some places where you want to force a full entry but those
are rare.

If you do use a mask (I hate them) teach your users to click on the label
rather than in the field. Clicking on the label puts the cursor in the right
place, clicking in the field usually forces back spacing.
 
Back
Top