Best way to store a percent value?

[Ruegen]

I have a table to store tax rates - 10% would about to 0.1 so I am guessing I store it as a double so that I have the decimal.



However I put this on the form and I have a text box formated with general number - it gives me the option of placing it to two decimal but is there a way to show it as a double as it keeps rounding it (.1 goes to 0)

[ItsMe]

If you are using an unbound control, perhaps the solution is to use something like #.000 in the format property. Or, maybe, use a DLookup function to grab the actual value and also the Fixed option in the control's format property.