>>>>I've got a UDF called S2MS() sitting in a procedure file which converts
>>seconds (numeric) to a formatted mm:ss string.
>>>>I had a grid in a form and one of the columns had S2MS(Duration) as the
>>control source. It worked just fine.
>>>>I moved this grid to a new form, and now the grid comes up blank (but
>>with grid lines and headings). If I remove the S2MS() function from the
>>column and just put in "Duration" it works normally, but of course my
>>seconds are unformatted.
>>>>Any ideas as to what's happened?
>>
>>>>
>>>>I've had this sort of thing several times with different "calculated"
>>columns and I'd love to know what's going on.
>>>
>>
>>>
>>>Hi Devid,
>>>Are you playing with Grid's rowsource or trying to change Datasession?
>>>this could blank out grid's definition
>>>Jayesh
>>>
>>
>>Sometimes, I (and another developer) have had trouble copying a grid and
>>then changing a piece of info within the grid. Sometimes that piece
>>of changed info just doesn't take.
>>
>>The only way around it seems to be to recreate the grid from scratch.
>>I also wish I knew why we have to do this, especially on big grids.
>
>I've found that sometimes the only answer is to recreate it too - unfortunately re-creating it in this case just doesn't work.
Normally, any sophisticated grid requires to be reset programmatically, i.e. you keep recordsource,column.controlsource(s) and other settings in custom method (form or grid subclass) and fire this method when necessary in code.
Edward Pikman
Independent Consultant