Form Date Autofill Field

[Gabriella777_2]

In a form I would like to put an autofill field that will insert the date the
form was filled in. But when it is opened at a later date, I do not want the
date to change to the day the form is opened.
How do I accomplish this?

 

[Greg Maxey]

Use a { CreateDate } vice { Date } field.

In a form I would like to put an autofill field that will insert the
date the form was filled in. But when it is opened at a later date, I
do not want the date to change to the day the form is opened.
How do I accomplish this?

 

[Gabriella777_2]

Is that a toggled field?

 

[Graham Mayor]

If you insert a Createdate field in your form, it will reflect the date the
form was created from the form template. If you insert a Date field it will
show the system date from the PC.
If you insert a Current date form field it will behave like a Date field.
If you insert a Date form field you will need a macro to autofil the current
date on entry to the field eg

Sub FillFormDate()
ActiveDocument.FormFields("Text1").Result = Format(Date, "dd/MM/yyyy")
End Sub

where text1 is the form field bookmark name and dd/MM/yyyy is the date
pattern

If you want to insert today's date in a document that you are opening to
edit, and not have it update, then you cannot do that without a macro and
that won't be of much use unless you know your users will allow the macro to
run.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Gabriella777_2]

Thanks for the help.
I did find the CreateDate, however, after talking to the person I was
creating the form for, I end up using some drop downs.
One for the month and one for the last 2 of the year. And a text box for
the day.
Thanks for everything.

 

[Graham Mayor]

http://www.gmayor.com/popup_calendar.htm might be more elegant?

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>