>>>Maybe someone could settle this once and for all. Is there a way to use a udf on a field as the controlsource for a column in a grid. I store a lot of data coded and use a conversion table to display the code. Right now I have to use an sql to do the udf and then use the resultant table (temporary) to as the source for the grid. A real pain.
>>
>>You can insert couple (I believe two would be enough) controls into column and use DynamicCurrentControl property.
>
>I don't understand this. Are you saying that if you put two text box controls in a column you can then use UDFs as the controlsource? What does the DynamicCurrentControl have to do with this? I thougth that allowed you to shift from one control to the other for a column.
>
>TIA for an explanation.
>
>Todd

I just meant that these different controls could have different control sources, so you can fill column from different fields. If you really want to have UDF you can do this but remember to refresh you grid any time your UDF will return new string-source name. I also think that it must be done programmatically or you have to use macros on property sheet. But anyway I agree with Tom that Init event is better place.