Programming an Outlook Form

[Chris Smith]

I have created a form in outlook and would like to
customize it. Is there anyway to create a text block to
input a date field and then have a separate field
automatically populate with a new value based on the
input, i.e., input a date in the field such as 4 Dec 03
and then have a separate field auto populate with date +
30 calendar days, i.e., 4 Jan 04?

 

[Hollis D. Paul]

I have created a form in outlook and would like to
customize it. Is there anyway to create a text block to
input a date field and then have a separate field
automatically populate with a new value based on the
input, i.e., input a date in the field such as 4 Dec 03
and then have a separate field auto populate with date +
30 calendar days, i.e., 4 Jan 04?

You want to use a Date/Time field for the input, not a text box, and a
second Date/Time field for the date plus 30 display. In the Date plus
30 field, define a formula that takes the value of Date1 and adds 30 to
it, and set it to compute all the time (not sure how that is phrased).
You may have to break the formula into a date part and a time part.
Make sure both controls are bound to fields.


Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA