Solved

Access 2010 Entering Percent Value

Posted on 2011-03-04
10
1,147 Views
Last Modified: 2012-08-13
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
Comment
Question by:dleads
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35035820
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
 

Author Comment

by:dleads
ID: 35036283
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35036289
..and, set the field ( control source of the textbox)  Field size property to double or single
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35036318
<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
 

Author Comment

by:dleads
ID: 35036373
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 35036454
< 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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35058505
<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
 

Accepted Solution

by:
dleads earned 0 total points
ID: 36421072
Apparently there is a setting on the local machines that control the way you enter percents.
0
 

Author Closing Comment

by:dleads
ID: 36445938
My questiion was not answered.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36446707
dleads,

could you elaborate, which setting on the local machines was altered ?
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
access vba 5 58
Why Won't My Excel Workbook Refresh The Data 2 47
Reoccurring Access Query 24 47
Access 2003, percentage between two fields 18 22
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question