Percentage Stored As Double: How To Format Data Entry?

[(PeteCresswell)]

I am storing a percentage in a Double field.

No problem formatting it for presentation (e.g. .33456 shows as 33.456%).

But when the user edits the field, they have to type in the decimal equivalent.
(e.g. .33456 for 33.456%).

What am I doing wrong?

 

[Allen Browne]

That's how Access has always worked, Pete.
Microsoft plans to fix in in Access 2007.

In the mean time, here's a simple fix:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html

 

[(PeteCresswell)]

Per Allen Browne:

That's how Access has always worked, Pete.
Microsoft plans to fix in in Access 2007.

In the mean time, here's a simple fix:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html

Thanx Allen. That did the trick.

What happens when 2007 comes out? Will my form be broken?

i.e. Should I think about adding a version check/notification to AutoExec?

 

[Allen Browne]

The form will still work okay in Access 2007.

The new version adds the % sign with the first keystroke.
The code in the link runs after Access has evaluated the value, and changes
it only if there is no percent sign. So the code runs harmlessly, doing
nothing at all in Access 2007.