How to remove decimals in combo drop down ?

[Michel S.]

Hi !

I have a combo based on a table. The dropdown list contains 2 columns,
an item number and a description.

The item number is defined in the table as Long Integer, Fixed format,
0 decimals.

The combo' format properties are also set to Fixed format, 0 decimals.
The item number displays correctly in the combo's fixed part.

Despite this, when the dropdown list opens, the item number is
formatted with 2 decimals.

How can I get rid of these decimals ?

Thanks

 

[Rick B]

Typically, an item number or part number would be a text field. If you do
not plan to do math with the contents, then you would not make it a number.

 

[Michel S.]

I agree that typically it should be a text field, but in that case it
isn't.

I have to live with decisions taken by others in the past and I can't
afford to check the entire application to find if I can safely change
the field from numeric to text without inducing side effects.

That said, how can one remove/set/change the decimals from a combo's
drop down list when one of the columns is a numeric field ?

Thanks.


Dans son message précédent, Rick B a écrit :