Help: Combo Box Showing Decimals

  • Thread starter Thread starter Len
  • Start date Start date
L

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
 
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
 
Back
Top