Link to home
Create AccountLog in
Avatar of dleads
dleads

asked on

Access 2010 Entering Percent Value

Where would I find the Access setting to adjust how a percent value is added on a form?
One user enters 20 in a percent field and gets the value of 20%
Another user enters 20 in the same field of the same form and gets a value of 2000%

The percent field in the form is formated as a percent with auto in the decimal places

Is there a global setting that I've missed?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

in the after update event of the textbox,

private sub text0_afterupdate()

me.text0=me.text0/100

end sub

set the format property of the textbox to "Percent"
Avatar of dleads
dleads

ASKER

I am aware of this option, but my question is there a global setting?
Why would one user be able to enter 20 and get 20 and another user enter 20 and get 2000?
..and, set the field ( control source of the textbox)  Field size property to double or single
<Why would one user be able to enter 20 and get 20 and another user enter 20 and get 2000?>

are the two pc in the same location?
are they using the same database?
is your database application split, BE and FE?
Avatar of dleads

ASKER

It is on a terminal server.  Access 2010 is the front end and SQL is the backend.
Each user has to set their Access options individually.  Is there a setting in the options that determines how it handles entries of percents?
< Is there a setting in the options that determines how it handles entries of percents?>
i don't think there is such option.(as far as i know)
<Access 2010 is the front end and SQL is the backend.
Each user has to set their Access options individually....Each user has to set their Access options individually>
That does not directly answer his question...

Does each use having their own copy of the font end installed of their local machine?
(Not "sharing" the  front end)
ASKER CERTIFIED SOLUTION
Avatar of dleads
dleads

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dleads

ASKER

My questiion was not answered.
dleads,

could you elaborate, which setting on the local machines was altered ?