Hi Gavin, I still have the form function - that didn't work, so I tried the procs function, but eval() worked as Al suggested. Now I'll retry the form function with and without the evaluate.
Regards
Dave
>Hi Dave,
>
>How about:
>
>
>ThisForm.MyGrid.MyColumn.ControlSource = "ThisForm.MyFunction(mytable.fieldname)"
>
>
>Hope this helps,
>Gavin...
>
>>Yikes, I've asked this before; but how do I make one column in a grid, which is otherwise bound to a table show the value of a user defined function,
>>eg grid.controlsource= myfunction(mytable.fieldname)
>>I can't seem to make it work, it either falls over or shows a value from the grid recordsource from the nth attribute of the table, n being the column number.