-
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
-
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".
-
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 :)