Combobox Format

[giedrius]

Strange format in dropdown list of a combo box

Hello,

I have a combo box where I can choose a number from a drop-down list. Rather than displaying '1' or '2', it displays '1.00' or '2.00'. Format = Fixed, decimal places = 0. After I choose the number, the value in the combo is properly displayed as '1' or '2'. The drop-down list is based on a query's field int(productCode) with format fixed, decimal places = 0.

Same happens with the alignment. In the drop-down list the values are left-aligned, while after entering the value, it is displayed as right-aligned in the combo-box (as specified in the relevant combo-box's property).

Where do I set properties for the drop-down portion of a combo box? Can anybody help?

Thanks,

 

[neileg]

If the combo is based on a query, try formatting the query.

 

[giedrius]

I formatted it with format=fixed, decimal places = 0. There is nothing else I can format, isn't it?

giedrius

 

[o1110010]

You can set formats in the design of a table, with expressions in a query, or in the properties of an object (ie. the combo box on the form). i normally make all the formats done at the highest level (instead of in the table). i am not sure if one over-rides the other.. i'll have to check on that. i think Mile-O-Phile posted a reply once about this.. *thinks*.