devxlogo

Displaying Formatted Data

Displaying Formatted Data

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist