General information
Category:
Forms & Form designer
>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?
Hi Kamal
Thats a good point. I haven't set anthing in the Format/Mask. The returned value is character and the function argument is numeric
>
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only