Most users are used to type “30″ in order to set Excel cell value to 30%;
MS Access 2003 do not permit it, in fact it need “0.3″ value in order to set 30%; MS Access 2007 seems to be same as Excel.
Here, How to enter percent values in Access efficiently, you may find a solution: on After Update event reassing same value, with a hundred part … like this: (pasted from the source):
Me.percentfield.Value = Me.percentfield.Value / 100
source:How to enter percent values in Access efficiently
Technorati tags: MS Access
Tags: C# Programming
