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