>I've tried what you said.
>
>But the value returned is 0 for all records, it doesn't appear to picking up a value in the function.
>
>Any other suggestions?
>
>Thanks
>Kev

Hi Kevin,

I just sent you a sample form which does what I say. Since there is no native TTOS() function, there are 2 grids with the function as column2.controlsource:
TTOC(table1.timestamp) and the form method thisform.ttos(table1.timestamp)
Please let me know if it is what you want.

HTH,
Nick