Wrong default in end and start date and company fields

J

JRO Mtn Group

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

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
 
J

JRO Mtn Group

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
 
S

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
 
J

JRO Mtn Group

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

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