Dates in Text Form Field

6

66stang

I have a form that requires dates to be entered into it, this form was
originally created in Word 97. After migrating to Word 2007 a problem
appeared in that when a user was trying to enter the date April-05, it
defaulted to the year to 08. I went into the Text Form properties and
changed the date format to XXX-yyyy from XXX-yy. This fixed the problem as
long as you enter the year as yyyy, if you only enter the year as yy it will
convert this to the year 2008 no matter what year you typed in. This being a
form I can not guarentee that all users will enter the year using yyyy no
matter how many directions given to them.

Is there a fix for this?

Thanks
 
G

Graham Mayor

If you set the field type to date and only type part of the date ie 04/05
for April 05 then Word fills in the current year to produce 04/05/08 which
means that if you have a date switch MMMM-yy you would get MAY-08 and not
APRIL-05 (the exact result depending on the language settings that determine
the date format at your location). The only way to avoid this is to enter
the complete date.ie 13/04/05 or 13/04/2005 which will give you APRIL-05.
The only alternative is to make this a Text field and then you can type
anything in it, but then you would have to rely on the user typing the date
format correctly. Either way you can add help text to the field to explain
to your users what is required.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
6

66stang

Thank you

Not the answer I was hoping for but at least now I understand why it is
happening.

I will add the help text and hope for he best!!
 

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