<div>
Am going with the first solution but all 3 very worthwhile.
</div>


Am going with the first solution but all 3 very worthwhile.

<div>
<div class="content wysiwyg-content">
I have a combobox that is displaying decimals in a field named 3DigitCode and I cannot figure out why.<br />
<br />
Here is the SQL of the code behind the combobox:<br />
<br />
SELECT tblPartNumberItemMasterTab<wbr />le.ItemMas<wbr />terID, tblPartNumberItemMasterTab<wbr />le.[3Digit<wbr />Code] AS Code, tblPartNumberItemMasterTab<wbr />le.DataMas<wbr />terDescrip<wbr />tion1 AS [Description 1], tblPartNumberItemMasterTab<wbr />le.DataMas<wbr />terDescrip<wbr />tion2 AS [Description 2]<br />
FROM tblPartNumberItemMasterTab<wbr />le<br />
ORDER BY tblPartNumberItemMasterTab<wbr />le.[3Digit<wbr />Code];
</div>
</div>


I have a combobox that is displaying decimals in a field named 3DigitCode and I cannot figure out why.

Here is the SQL of the code behind the combobox:

SELECT tblPartNumberItemMasterTable.ItemMasterID, tblPartNumberItemMasterTable.[3DigitCode] AS Code, tblPartNumberItemMasterTable.DataMasterDescription1 AS [Description 1], tblPartNumberItemMasterTable.DataMasterDescription2 AS [Description 2]
FROM tblPartNumberItemMasterTable
ORDER BY tblPartNumberItemMasterTable.[3DigitCode];

How keep number field in a combobox from displaying decimals

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.