Type correction help.

[JGalletta]

It is my impression that Len(Combo50) defaults to the Len(Combo50.Value). Len(Combo50.Value) would not contain any commas for this calculation to work (and would only contain the first value of the values selected in a multivalue field), which is why I used Len(Combo50.Text) to specify that I am not looking to use Len(Combo50.Value) in this calculation.

Confused yet? Haha, well I know I was when I ran into this situation. This seems to be one of the evils of using multivalued fields. You cannot get a count of selected values unless you have the actual form and field selected in the form view of the form collecting this data. At that point you can use the Selected.Count property of the control (or something to that extent) to obtain the amount of values selected in the control, but this cannot be acquired from a query/report such as in this instance. Hence, the Len/Replace Mess I created.

 

[pr2-eugin]

I understand what you are trying to do, but unfortunately, I have no idea on Multivalued fields.. So I have to say I give up..

 

[JGalletta]

Well, I really appreciate your attempt at helping me anyway. Thumbs up.

 

[JGalletta]

If anyone else is still interested in helping with this issue. Is there a way I can get these calculations to be performed prior to the report level, like in a query that I can reference from the report?