Format percentage

[Vulcan1500]

I must do something very stupid! I have a table with different VAT's. This table is used for a combobox on a form to select a VAT. What keeps puzzling me is that the selection in the combo always shows 2 decimal digits instead of one. What am I doing wrong here?

 

[RoyVidar]

What is displayed in combos/lists is text, so any number formatting applied, usually doesn't show. You probably need to format in the query. In the rowsource property of your combo, try

SELECT pkVAT, Format(VAT, "0.0%") FROM VAT

Note that if there are more than one decimal, using this, it gets truncated!

 

[Vulcan1500]

Thanks for your advice RoyVidar. That does the trick.