Logic on Percent format????

Maybe someone knows the logic behind MS Access for the display of percents in the formating..... ie.... If you input 3 you get 300.00%. I really dont think ANY user would look at a form... with a field called...say "Commission percent" and expect an input of a 5 to return 500.00% Does this need to be corrected with coding?

It is not just Access , Excell is the same and I suspect it is the standard way to do it.
Don't use the % format if you want to display the integer value, just put a lable with the '%' Next to the field to keep it clear.

HTH

Peter

Percentage values should be specified using a single or double data format: ie. 5.00% is actually stored as 0.0500, and 78.33% is actually stored as 0.7833. This is done this way to lend functionality to calculated fields.

For example, if you want to calculate a given employees percentage of total sales you would divide his sales figure by the total sales figure. This returns a decimal value like "0.2648". Using the percentage format on this calculated field will display this information as "26.48%".

If you decide you must use integer data types with the percentage format, try modifying the "Control Source" property of the control:

=[MyField]/100