Another form question

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?
 
S

Suzanne S. Barnhill

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.
 
S

Suzanne S. Barnhill

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.



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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top