Hi David,
Try calling a form's method which would in turn return the value. You may even call the S2MS() function from this form's method. Though the first thing I would go for is to have RETURN "WORKS" in this method and then check wether it works with the S2MS() function.
Regarding the format, Are you setting the Column's Format/InputMask property or the Control in the column?
>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.