Question:
I have defined a field as Double in my Table to store prices. Then I bound my database to a grid.I would like to display the contents of the field in certain format such as #0.00, but it doesn’t work.The data used to be displayed in brief format such as 8, 9.3, 23, etc, which I would like it to be display as 8.00, 9.30 and 23.00.
Answer:
Depending on the type of grid you are using, you can either do it manually with the Format$ statement, or use the built-in formatting properties of grids like Sheridan and Apex.
