Combo Box showing decimals - how to remove decimals?

[UNC_Access]

Hi! I am trying to fix a combo box to remove decimals. Here is the info:

1. The combo box is used to search records in a form. It is linked directly to a table. A field called "OP" is the item that needs to be searched. "OP" is a four-digit number.

2. Here is the "OP" field's properties within the table:

3. Here is the Combo Box's properties on the form:

3. However, despite these property settings, I still get this:

What should I do to remove these decimals?

Thanks!

 

[spikepl]

The property you set in item 3. relates only to display of the selected value - not how the values in the list are formatted. That you did set in 1. to Fixed, which causes your predicament. Remove the content of Format.

 

[UNC_Access]

Perfect! Thanks for the quick help!