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.