How to format a combobox?

[Nirious]

I have a combobox wich contains values from a table column with numbers in it.The number can go from 0 to 9999999999999 so I needed a double to be able to store numbers of this size.

So I set the properties of that column to fixed fith 0 decimal places.
I also set the combobox's properties to this and indeed the numbers show just fine in the boxitself , but when I click on the combobox to get the list, all numbers in the list appear like this:

1,00
2,00
3,00

enz...
And I can't get those zero's to disappear. :-/

Is there another way than to make the field a textfield to get rid of those zero's.

 

[stephen81]

So I set the properties of that column to fixed fith 0 decimal places.

In your table, set the properties of that column to general number, not fixed.

 

[Nirious]

thx that did the job