• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1161
  • 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 free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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