Hi Dave,
If I do it in the Properties Box I can set the ControlSource of the Column to ThisForm.UDFField() without quotes and it works fine. If I do it with code I can do something like:
ThisForm.MyGrid.MyColumn.ControlSource = "ThisForm.MyFunction(mytable.fieldname)"
and it also works.
Regards,
Gavin...
>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.