How do I format the numbers in an MSHFlexGrid column to one decimal place.
I have an MSHFlexGrid that is displaying Item numbers in the first column from an Access database. The datasource is an ADODC. I am performing a query on the database as follows:
adoSavedData.RecordSource = "SELECT * FROM savedorder WHERE ref = '" & VarOrdNo & "' ORDER BY item"
I am then filling the MSHFlexGrid with the results of the query. The 'item' field in the database is set to a Data Type of Number(Double). Typical item numbers in the database are 1, 1.1, 2, 2.1 etc. The problem is where there is an item number of e.g. 1.1 it is displayed in the FlexGrid as 1.1000000000000001 instead of 1.1
Any help much appreciated.
I have an MSHFlexGrid that is displaying Item numbers in the first column from an Access database. The datasource is an ADODC. I am performing a query on the database as follows:
adoSavedData.RecordSource = "SELECT * FROM savedorder WHERE ref = '" & VarOrdNo & "' ORDER BY item"
I am then filling the MSHFlexGrid with the results of the query. The 'item' field in the database is set to a Data Type of Number(Double). Typical item numbers in the database are 1, 1.1, 2, 2.1 etc. The problem is where there is an item number of e.g. 1.1 it is displayed in the FlexGrid as 1.1000000000000001 instead of 1.1
Any help much appreciated.