Formating Dbgrid?

[CoMMiE]

Hi
My question are:
1)How can i format the dbgrid so that it can accept floating point numbers instead of round numbers?

2)I am currently doing a project that require the use of cents, how do i convert a number like 14.5 in a textbox to 14.50??


Any suggestion or help will be greatly apreciated

[Draez68]

not sure about question 1 since i use the flexgrid but #2 is easty:

use the Format command -

' User-defined formats.
MyStr = Format(5459.4, "##,##0.00") ' Returns "5,459.40".
MyStr = Format(334.9, "###0.00") ' Returns "334.90".
MyStr = Format(5, "0.00%") ' Returns "500.00%".

MyStr = Format("HELLO", "<") ' Returns "hello".
MyStr = Format("This is it", ">") ' Returns "THIS IS IT".

[CoMMiE]

Hi Draez68
I tried your suggestion for question 2 and it really works
Thanks a lot

About question1 can you post on how to format a flexgrid, my guess is the way you frormat a dbgrid is the same as flexgrid

thanks again