Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 10th, 2005, 12:45 PM
Authorized User
Join Date: Feb 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with Number Formatting


I have a problem with a table that has number formats setup as usual - #,##0.00;(#,##0.00) and formatted to 2dp. However when inputting say 1.58 into the table it will round to 2.00 and does not show any decimals except as .00. When I remove the number formatting and set the decimal place to Auto, or 1 the same occurs but no decimal places are showing.

Can anybody explain why this is happening? I have tried searching through the properties, etc. to no avail.

Thanks very much for your help,


Old July 10th, 2005, 02:00 PM
Friend of Wrox
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post


In your table, make sure the number type is either single or double. It cannot be long or integer as these will round up or down.
Single or Double will keep the decimal places.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Number formatting / RegExp pierre.voisin Javascript 0 March 3rd, 2008 01:50 PM
Textbox Number Formatting pencilneck Visual Basic 2005 Basics 2 October 25th, 2007 03:46 PM
formatting number vkey XSLT 1 June 22nd, 2005 02:29 AM
formatting number dhol General .NET 2 February 24th, 2005 12:47 PM
Formatting a number eelisMX Pro VB.NET 2002/2003 7 January 28th, 2005 05:22 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.