OK, so are you doing it in code or in the properties box with or without the quotes??
BTW I'll wont be able to reply till Friday :-(
CU then Dave
>Hi Dave,
>
>That's strange, the way I suggested works for me.
>
>Gavin...
>
>>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.