Combo Box displaying wrong values....help!!!

[JustMaybe]

Hi, have a really weird problem, I have a combo-box on a form, which displays a choice of 3 percentage values. These values came from a table. However when you select a value the format changes in the actual text box! E.g. If you select the value 5.0% then it will appear as 0.05 in the field! The strange thing is this has just started happening! I didn’t change anything…I think! And everywhere the values format is written as ‘percent’.
Also I made a form of the original table, and this seemed to display the values fine!!

Can anyone help..please??

 

[Rich]

Set the Format in the combo's underlying query/SQL

 

[JustMaybe]

Thanks Rich,
i've tried this, but it just does'nt want to be a percentage!

Am i missing something simple?

 

[casey]

Also, try checking the format in the actual table field. Perhaps you can find the correct format there! It seems that the table takes precedence.

 

[glynch]

I have found that formatting a field in a table doesn't really "change" the value that is stored, it only changes the appearance to match the chosen format. So even though the table and the query feeding the combo look like 5.0%, Access is really storing the 0.05 value. Isn't there a way to format the actual displayed value in a combo? I would try that.

 

[skwilliams]

The VATID field in the table ORDERS should be is formatted as a percentage but the field size is Integer.

Try changing to Double.

This should work.