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?
Microsoft Access

Avatar of undefined
Last Comment
Rey Obrero (Capricorn1)

8/22/2022 - Mon
Rey Obrero (Capricorn1)

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"
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?
Rey Obrero (Capricorn1)

..and, set the field ( control source of the textbox)  Field size property to double or single
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Rey Obrero (Capricorn1)

<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?
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?
Rey Obrero (Capricorn1)

< 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)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jeffrey Coachman

<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
dleads

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
dleads

ASKER
My questiion was not answered.
Rey Obrero (Capricorn1)

dleads,

could you elaborate, which setting on the local machines was altered ?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck