Help: Combo Box Showing Decimals

[Len]

When creating an unbound combo box based on one of the
fields in a table I am showing 2 decimal places when
clicking on the drop down arrow. The field is set up as an
Integer field, format fixed, 0 decimals. No matter what I
do I get 2 decimals when clicking on the drop down arrow.
I do not want to show any decimals because the field is a
whole number. I am using this field to search for all the
records with that criteria and show only those records
that are retrieved.
Thanks,
Len

 

[Jeremiah Ellison]

In your table design, the field is likely specified to allow 2 decimals. Please check and reply if that's not the case.

When creating an unbound combo box based on one of the
fields in a table I am showing 2 decimal places when
clicking on the drop down arrow. The field is set up as an
Integer field, format fixed, 0 decimals. No matter what I
do I get 2 decimals when clicking on the drop down arrow.
I do not want to show any decimals because the field is a
whole number. I am using this field to search for all the
records with that criteria and show only those records
that are retrieved.
Thanks,
Len

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts