Another form question

  • Thread starter Thread starter Cheri Gamble
  • Start date Start date
C

Cheri Gamble

Is there a way to format one of the form fields for a
date so that all you have to do is put in the numbers and
it automatically formats it to mm/dd/yy? Example 12/24/04
could be typed in 122405 and the slashes would auto format?
 
Yes, but don't try to do it as a date--for some reason date fields are very
picky about what type of input they will accept. Do it as a "number"
instead. Note, however, that users will have to enter leading zeroes for
this to work.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
The text to display can be 00/00/00 (to give users a hint), but the number
format should be ##/##/##. You won't see a change till you tab out of the
field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Cheri said:
Can't make that work. Are we on the same page? I've created a letter and
where a date needs to be inserted I've called up the Form toolbar and made a
text form field - when I right click and select properties, I get the option
to make it a number, date whatever. I chose number. Entered ype =
number, max length 8 (00/00/00), text format 00/00/00 checked calculate on
exit and the OK - but when I type in the number it doesn't format it with
the slashes. What am I not doing right?
 
Back
Top