Board index » delphi » Field - Edit,Display Format

Field - Edit,Display Format

2005-06-01 02:34:22 AM
delphi83
D7, IB 6.02
My Detail Table has UnitPrice ( Double Precision ) field.
to show the unit prices with 3 decimals ( 0,005) i made field's
EditFormat #,### and Currency=False,
But this time i cant see 1,50 or 23,20 i see 1,5 or 23,2
( no zero at the end )
How can i solve this problem ?
Thank You.

Re:Field - Edit,Display Format

#,000
--
Bill Todd (TeamB)
LG writes:
Quote
D7, IB 6.02

My Detail Table has UnitPrice ( Double Precision ) field.
to show the unit prices with 3 decimals ( 0,005) i made field's
EditFormat #,### and Currency=False,
But this time i cant see 1,50 or 23,20 i see 1,5 or 23,2
( no zero at the end )
How can i solve this problem ?

Thank You.

Re:Field - Edit,Display Format

D7, IB 6.02
Quote
#,000
Thank you Bill,
I change the field's EDITFORMAT to #,000 but
1- I still cant see zeros at the end , i see 1,3 ( instead 1,30 )
2- instead of 1.124,55 i see 1124,55 ( No digit gropuing symbol )
I think i cant explain my problem,
My problem is : If my numeric field ( double precision) has 3 decimal
then i want to see it with 3 decimal, if it has 2 decimal i want to see with
2 decimal. For example 0,095 - 12,00 - 1.245,50 - 15.558,32 -
215.300.00 - 1.365.500,80
Thank You.

Re:Field - Edit,Display Format

Henry Olive writes:
Quote
D7, IB 6.02

>#,000

Thank you Bill,

I change the field's EDITFORMAT to #,000 but
1- I still cant see zeros at the end , i see 1,3 ( instead 1,30 )
2- instead of 1.124,55 i see 1124,55 ( No digit gropuing symbol )

I think i cant explain my problem,
My problem is : If my numeric field ( double precision) has 3 decimal
then i want to see it with 3 decimal, if it has 2 decimal i want to see with
2 decimal. For example 0,095 - 12,00 - 1.245,50 - 15.558,32 -
215.300.00 - 1.365.500,80
^ 215.300,00 ?

Thank You.

Try
TNumericField(YourField).DisplayFormat := ',0.00#'
(I don't know if the # is necessary)
Magnus

Re:Field - Edit,Display Format

Try #.###,000 and set the DisplayFormat property, not just EditFormat.
--
Bill Todd (TeamB)