Outlook form

G

Guest

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

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
 
G

Guest

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
 
S

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
 
G

Guest

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

Sue Mosher said:
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 said:
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
 
S

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



Mike said:
Only when I create a new form.
I emailed you a screenshot

Sue Mosher said:
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].

Mike said:
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.
 

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