percent format differing by computer

[Guest]

On my machine Access2003 in application I made; I enter number 1 when wanting
1% with the form's AfterUpdate Event doing the 1/100 so it does not show as
100%. The form's field is defined as percent and the table's field is
defined as decimal.

Got this hint from this site - works fine.... while I myself am happy to
enter .01, but was told the user expects to enter a whole number for the
percent value...fine; works great...

But much to my surprise I loaded the application on the user's PC and this
field is showing .01%

So am scratching my head and wondering why it looks one way on my machine
and another on theirs? would welcome advice...tia

 

[John W. Vinson]

But much to my surprise I loaded the application on the user's PC and this
field is showing .01%

So am scratching my head and wondering why it looks one way on my machine
and another on theirs? would welcome advice...tia

You can enter 0.01 (displayed as 1%) by either typing .01 *or* by typing 1%
(with the extra keystroke). Could that have been how it got in?

John W. Vinson [MVP]

 

[Guest]

If John is right then you can prevent users entering the percent sign by
putting the following in the control's KeyPress event procedure:

Const PERCENTSIGN = 37

If KeyAscii = PERCENTSIGN Then KeyAscii = 0

Ken Sheridan
Stafford, England

 

[Guest]

thnks both Ken & John - have copied your replies over to a file I'm keeping
on managing these percent fields...but let me restate same issue slightly
differently and see if your advice differs;

I look at this nonsplit DB direct at its table and see decimals i.e. .01.
In my Form I see 1%. I load this myself onto the user's PC and in that same
form I see .01%

My first thought was similar to a situation I've seen involving presentation
of date format is that the OS has a setting which defines it. I had an app
where my medium date was 8/9/07 but when loaded on the user was showing as
9-Aug-07.

So am wondering why using the same app that on one machine it appears as 1%
and on another machine, same app, it appears as .01%. If you say that it can
not be then I will assume I was have a senior moment but took pretty good
notes and came away with this question mark....

 

[John W. Vinson]

So am wondering why using the same app that on one machine it appears as 1%
and on another machine, same app, it appears as .01%. If you say that it can
not be then I will assume I was have a senior moment but took pretty good
notes and came away with this question mark....

Something's different about that machine, then. Either the format or code on
the form is different, or the table content is different, or the database is
corrupt.

John W. Vinson [MVP]