List Box and Integers

[Dave D]

One of the fields I'm showing in a list box is of type Integer; however, when shown in the list box it displays as a whole number.



For example, if the field in the table has the number 123, it displays in the list box as 123.00. Can I correct this behavior, or am I stuck?

[Missinglinq]

Doing this in 2007, using the Listbox Wizard, I can't reproduce your problem. How did you populate the Listbox?

Linq ;0)>

[Dave D]

like you, I am using the list box wizard.

[Missinglinq]

This isn't a calculated value, is it? When calculations are done the Access Gnomes sometimes will do this, with the results.

Linq ;0)>

[Dave D]

Alas, I found the problem - nope, not a calculated value - but a format setting in the table itself. The table had the following:

Field Size: Integer
Format: Standard
Decimal Places: 0

I deleted the format and it now works as advertised.

Thank you for trying to help, 'linq.