I don't think you can do that. How about using the Function in the Select command?

Aloha,

James
>I am trying to use a function in a ControlSource of a grid column. And I thought I have done it before but it does not work now.
>
>SQL Select creates a cursor where one of the columns is DEP_ID (1 character).
>
>I set ControlSource as ServiceDepartment(DEP_ID)
>
>I have function
>

>FUNCTION ServiceDepartment
>LPARAMETER cDepId
>do case
>   case cDepId = "M"
>       RETURN "MAINTENANCE"
>   case cDepId = "G"
>      RETURN "GROUNDS"
>

>
>If I include argument in the ControlSource function name I get error. If I don't include the argument, only 1-character field is returned.
>
>What am I missing? TIA.