Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1163
  • Last Modified:

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?
0
dleads
Asked:
dleads
  • 5
  • 4
1 Solution
 
Rey Obrero (Capricorn1)Commented:
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"
0
 
dleadsAuthor Commented:
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?
0
 
Rey Obrero (Capricorn1)Commented:
..and, set the field ( control source of the textbox)  Field size property to double or single
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Rey Obrero (Capricorn1)Commented:
<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?
0
 
dleadsAuthor Commented:
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?
0
 
Rey Obrero (Capricorn1)Commented:
< 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)
0
 
Jeffrey CoachmanMIS LiasonCommented:
<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)
0
 
dleadsAuthor Commented:
Apparently there is a setting on the local machines that control the way you enter percents.
0
 
dleadsAuthor Commented:
My questiion was not answered.
0
 
Rey Obrero (Capricorn1)Commented:
dleads,

could you elaborate, which setting on the local machines was altered ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now