Outlook form

[Mike]

I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.

 

[Sue Mosher [MVP-Outlook]]

Show how you're using the Now() function in your form.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Mike]

Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form

 

[Sue Mosher [MVP-Outlook]]

Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Mike]

Only when I create a new form.
I emailed you a screenshot

Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form

 

[Sue Mosher [MVP-Outlook]]

Could you post your screenshot on a web site somewhere please?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Only when I create a new form.
I emailed you a screenshot

Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form


:

Show how you're using the Now() function in your form.

I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.