Wrong default in end and start date and company fields

[Guest]

I have created a custom Journal Form - Page 2. I have added the field End
Date - but it defaults to the date the form was created - as does the start
date. I have also added the field "company" from the journal field picker -
it also defaults to the date the field was added to the form,,,,,,why is
this. (I know that this field is not related to contacts-I need to it record
which Group did the work - and I'd like it to default to a particular text)
The form was designed to be just like the default main page - but to include
the end date so that the duration would be calculated.
Thank you!

 

[Sue Mosher [MVP-Outlook]]

You can put code in the form's Item_Open event handler to set start to right now:

Function Item_Open()
If Item.Size = 0 Then
Item.Start = Now()
Item.End = Now()
End If
End Function

You also could use a formula on each date field's control to accomplish the same thing.

I don't know why the Company field would be playing games, but make sure you haven't set an initial value for it.

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

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

 

[Guest]

I'm not very experienced - how do I put a formula in the control- for the
date fields? I tried assigning the company field to a default text value but
that didn't work either.
I appreciate your help

 

[Sue Mosher [MVP-Outlook]]

Open the form in design mode. Drag the desired field to a custom page. Bring up the PRoperties dialog for the field and switch to the Value tab. Under "Initial Value," enter Now as the formula.

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

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

 

[Guest]

I Got it!! - Thanks. I got the initial value in the company field to work by
putting quotes around it - yippee