Problem with Combo Box

[adwaitjoshi]

I have a combo box which looks up for its rows from a table. The entry in the table is integers with explicitly defined decimal places (0 in this case) However when the combo box shows up on the form it shows values with two decimals. I tried changing the properties to fixed and zero decimal places and it did not work. The query shows no decimal places. Also when a value in the combo box is selected the decimals go away. They are only seen when the menu is pulled down. Please help me !!!

 

[R. Hicks]

Try using the Int() function in a "Field Expression" in the RowSource query the combo is based on.

ExpName:Int([FieldNameFromTable])

Change "ExpName" to whatever you want (other than a field name already used in the table).

Change "FieldNameFromTable" to the actual name of the field of information being used as the lookup value from the table.

HTH
RDH

 

[adwaitjoshi]

What is the ExpName Exactly sorry but I am a little new to Access

 

[DBL]

It's just the name that you want to call the new field, Ricky's just given you ExpName: as an example. As he says, you can call it anything you like as long as it isn't the same as the field already named in your table.

 

[adwaitjoshi]

Ok got it working thanx a lot for your help guys I really am grateful to all of you