Problem with Combo Box

[adwaitjoshi]

I have a form in which I have a combo box. This combo box looksup for its values from a table and then depending on this table it searches for the respective entries in the table. The values in the tables are plain numbers without any decimals. Also in the form, the decimal places of the combo box are shown to be zero. Still when I pull down the combo box, it shos 2 decimal places. When i select any particular value the decimals go away. But it looks wierd when you pull down the menu and see the participant number as 1.00 I tried to check in the form, table and the query but not able to solve the problem. Please help me !!

 

[Travis]

When your run only the Query, do the Decimal Places appear?

 

[adwaitjoshi]

No the decimals dont occur

 

[Travis]

The combo box control. Is the Decimal Places Set to Auto or Zero (0)?

 

[skwilliams]

Try changing your data type to an integer which are identified as whole numbers.

 

[adwaitjoshi]

The decimals are set to 0 the format to fixed and the type to integers. still this thing is happening I am kind of confused. Please help.