Combo Box Displaying incorrect decimal places.

[BrianE]

Hi,

I have a combo box that selects Barcodes. I have set the format to fixed, 0 decimal places, yet the Combo Box still displays 2 decimal places (.00)

I have checked the field on the table where the Barcode is called from, it is also set to Fixed, 0 decimals.

My SQL Code for the Combo Box is:

SELECT tblInventory.Barcode, tblInventory.[Item Code], tblInventory.[Item Description], tblInventory.Suspend
FROM tblInventory
WHERE (((tblInventory.Suspend)=No));

How do I fix this pesky problem?

Thanks
Brian
Pretoria
South Africa

 

[KenHigg]

Is the it a text data type? If so can you simply put it in a cint() function?

 

[BrianE]

Hi Ken. The Barcode is a number format field. Just got an idea, if I try int(field name)... Nope, that doesn't help.

Is the it a text data type? If so can you simply put it in a cint() function?

 

[gemma-the-husky]

what are your column widths for the combo box, and what is your bound column - ie are you seeing column(0) or a different column

 

[missinglinq]

You say the Barcode is "number format field." That's somewhat ambiguous; are you saying it's formatted as a numebr in the form, or is it defined as a number in the table? If it's defined as a numeric datatype in the table and its Field Size is set to Integer, as it should be, there's absolutely no reason for decimals to show up. You might also check the settings in the control's Property sheet to be sure they're actually as you think; Access has a bad habit of not always retaining the changes you make there.