>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.