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
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)
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)
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.
private sub text0_afterupdate()
me.text0=me.text0/100
end sub
set the format property of the textbox to "Percent"