Can Not set LABEl field on form

[JimBob]

I have created a custom form to create "events" on the calendar unique to my
business. I would like to control the color of the calendar entires based on
the value in another field on the form.

When I try to set the value of the LABEL field on the form by putting a
formula in the property section - nothing happens. Is there something
special about the LABEL field?

 

[Sue Mosher [MVP-Outlook]]

What kind of formula? Did you bind the label control to an Outlook property?

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

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

 

[JimBob]

Thanks Sue -

For my Formula I selected the Label object, went into Properties, Value
(Tab) then in the section Initial Value I checked the Set Initial Value box
and selected "Calculate this field automatically" and put this formula in:

iif([EventStatus]="Committed","Important","Travel Required")

I am not so sure about binding, in advanced properties it says Bound
Column=1. I just dragged the LABEL field form the field list under "All
Appointment Fields".

 

[Sue Mosher [MVP-Outlook]]

Ah, we're talking about two different things. There actually is a type of control called a label. I thought that's what you meant. Your explanation makes clear that you are working with the appointment color label instead.

The value stored for that field is actually a number, not a string. Therefore, you just need to use the right numeric values:

iif([EventStatus]="Committed",1, 6)

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

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

Thanks Sue -

For my Formula I selected the Label object, went into Properties, Value
(Tab) then in the section Initial Value I checked the Set Initial Value box
and selected "Calculate this field automatically" and put this formula in:

iif([EventStatus]="Committed","Important","Travel Required")

I am not so sure about binding, in advanced properties it says Bound
Column=1. I just dragged the LABEL field form the field list under "All
Appointment Fields".

 

[JimBob]

Yow! Much love - works like a charm!

Ah, we're talking about two different things. There actually is a type of control called a label. I thought that's what you meant. Your explanation makes clear that you are working with the appointment color label instead.

The value stored for that field is actually a number, not a string. Therefore, you just need to use the right numeric values:

iif([EventStatus]="Committed",1, 6)

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

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

Thanks Sue -

For my Formula I selected the Label object, went into Properties, Value
(Tab) then in the section Initial Value I checked the Set Initial Value box
and selected "Calculate this field automatically" and put this formula in:

iif([EventStatus]="Committed","Important","Travel Required")

I am not so sure about binding, in advanced properties it says Bound
Column=1. I just dragged the LABEL field form the field list under "All
Appointment Fields".

I have created a custom form to create "events" on the calendar unique to my
business. I would like to control the color of the calendar entires based on
the value in another field on the form.

When I try to set the value of the LABEL field on the form by putting a
formula in the property section - nothing happens. Is there something
special about the LABEL field?