Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Developers    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Rounded Numbers in Tables, Forms, and Queries
Kirk Barry 
    
10 months ago
I deal with fractional percentages, like .125      I have my fields set to Double, percentage, 2  in the table fields (I use calculations so these are my value selections).  If I enter .00125 in a field, it will enter as .125 but display as .13. The query will also display as .13 and the table will display as .13 but I can see that the actual value in the field is .125
I want the field to display as typed in the forms, queries, and tables, not rounded.  Help please
Donald Blackwell  @Reply  
       
10 months ago
Change the number of decimal places to 3 or 4, or even leave it as "Auto". When you set it to a specific number of places, Access just formats the value to show that number of places so it looks rounded.
Kirk Barry OP  @Reply  
    
10 months ago
Donald. Thanks for the assist. Auto did not work, but "4" did work.
Kevin Yip  @Reply  
     
10 months ago
Kirk   You need to type the leading zero in order for Access to process the percentage properly.  If your field is formatted as percentage, then:

If you type 0.125, Access will enter 0.125% (with the underlying value 0.00125, as it should be).  This is the way it's supposed to work.  You don't need to type 0.00125 just to get 0.125%.

But if you type .125 instead, Access will enter 12.5% instead.  This is due to a still-unfixed quirk of Access, covered in this video by Richard:

     https://www.youtube.com/watch?v=1NnW-5yKfxE
Kirk Barry OP  @Reply  
    
10 months ago
Thanks Kevin.  I do that. It actually makes some sense mathematically.  Typing the two zeros is the placeholder for tens and ones. I caught on to that one rather quickly. Thanks for the assist.
Kirk Barry OP  @Reply  
    
10 months ago
Update.  The problems continued with Access rounding.  I kept experimenting with the issue and I have found a solution that is stable.  with my field parameters set at Double, percent, 4;  If I want to have ".13" in a field, I enter "0.13"  Entering the "0" and the "." first works and Access does not round.  Importantly, the correct value is visible in the field for tables, queries, and forms.
Kirk Barry OP  @Reply  
    
10 months ago
Kevin, you were right. Thanks again.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 8/8/2026 6:05:26 AM. PLT: 1s