Solved

unbound txtbox ignoring decimal place property

Posted on 2007-03-21
3
247 Views
Last Modified: 2013-11-28
I have an unbound txtbox in which the Decimal Place Property is set as 2; however, calculated results are shown with decimal places being more than two.  Your thoughts?
0
Comment
Question by:zubin6220
3 Comments
 
LVL 7

Expert Comment

by:Imoutwest
ID: 18763427
IN design mode, select properties, click on the Format tab, and the first Field on the tab is also called Format.

Change or select Fixed from the Drop Down List. I will verify the Number format when I get to work.
0
 
LVL 39

Accepted Solution

by:
stevbe earned 200 total points
ID: 18763440
I think the decinmal place is only going to work for bound controls, you could force the correct display using the Format property

#,###.00
0
 

Author Comment

by:zubin6220
ID: 18763571
Just what I needed, Thanks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
unable to save new report from old one 9 27
VBA Access 2016 syntax 6 38
sql statement - 9 23
ms access filter query with empty combobox 5 28
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

813 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now