Steven has attended:
Access Intermediate course
Formatting percentages
When formatting a field to show % how do you stop the figures from automatically rounding up. For example i would like to show 99.71% so i type 0.9971 and it automatically rounds up to 100%. The problem that i face is that all of the records in this field range between 99 and 100% and i need to show them exactly to 2 decimal places.
RE: formatting percentages
Hi Steven, Thanks for the post, Try this in your table in design view:
Set the Field properties as follows:
Field Size : Decimal
Format : Percent (Or as per your own preference.)
Precision : 18 (Or as per your own preference.)
Scale : 4 (Has to be set in oder to display values after decimal seperator)
Decimal Places : 2 (Or as per your own preference.)
Hope that works, best regards Pete
