>Hello,
>
>I have a UDF called ConvToView that takes a value and converts it to a normal looking time. For Example, I store 5:00p in a table as 1700.
>
>My problem is I want a grid that has a column bound to this particular field but I need to run this UDF on it first. In other words I want 5:00p to show in the text box rather than 1700.
>
>I have tried to put in the ControlSource of the column ConvToView(ava_bgntime) but this doesn't work. I also tried to put the function call in the InterActiveChangeEvent of the text box in the column but this didn't work either. Any Ideas?
>
>Paul
If you will set ColumnX.ControlSource to Thisform.ConvToView(table.time) in Form Designer, then it should work Ok, assuming that ConvToView is form method.
Edward Pikman
Independent Consultant