Check Thread ID:
1522453 >How can I determine the field definition in a table that is format, and then use that in a Transform() function.
>
>Example: a field as N(5,2)
>
>What I ultimately want achieve is getting a string version that field that is formatted to the same number of decimals.
>
>Example, if the field is defined as N(5,2) and the values is 2.50, I want as string that reads “2.50”, if the value is 1.00, I want a string that is ”1.00”. But I cannot hard-code the number of decimals, it must come from the field definitions in the tables.
>
>If it is an integer, then it will not have any decimals.
>
>I must use the field data to determine the format of the string that I want to show in some html page I am building.
>
>Right now, when I use the Transfrom() function, it will omit the decimals if the value is a whole number.
>
>Transform(1.00) returns “1”, but I want “1.00”