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?
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
Last Comment
Rey Obrero (Capricorn1)
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?
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
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
<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?
are the two pc in the same location?
are they using the same database?
is your database application split, BE and FE?
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?
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)
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.
<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)
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
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
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 questionASKER
My questiion was not answered.
dleads,
could you elaborate, which setting on the local machines was altered ?
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
private sub text0_afterupdate()
me.text0=me.text0/100
end sub
set the format property of the textbox to "Percent"