Auto Decimal for percent format problem

[kchernak]

I'm stumped - I have a table with field 'RATE', set to Double, Percent, and Auto Decimal Places, but the table in Datasheet view only displays 2 decimal places max. I display this field in a form and have tried every combination of settings/formats to get the value to display as a percent with the correct number of decimal places (i.e. 0.051 should be '5.1%', and 0.54321 should be '50.321%'. Instead I just keep getting 2 decimal places (5.10% and 54.32% respectively).

Does anyone have a solution that would display only the correct number of decimal places up to a max of say 6?

Thanks

 

[malleykr]

The problem is that the 'Percent' format always gives 2 decimal places. Try setting your format to the following instead:
#.######%

That should give you up to 6 decimal places, and it will convert numbers to a percent.

Good luck.

 

[kchernak]

Bingo - worked like a charm - many thanks!