Yep and that's how I remember it working. Oh well! Clearly I've got something tangled.


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