Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / May 2005

Tip: Looking for answers? Try searching our database.

Rounding

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael Sainz - 02 May 2005 19:29 GMT
Hey all,
   I have built an order form and i'm trying to round to the nearest cent.
When I use an expression box, it does this, but when I use a text box (since
I need to store the price) I am unable to round up or down.

   For example, I have a unit with a price of $28.50 and it needs to have a
discount of 15%. That makes the price $24.225. In the expression box, it
displays $24.23 but in a text box, it creates a validation error and
displays $24.2250000. Now in the sample forms the text boxes for the Invoice
sample are able to do this rounding, so why am I unable to duplicate this?

Any help is much appreciated!

Michael
Michelle B - 03 May 2005 01:09 GMT
Make sure your field is a Decimal datatype and not a string.  In the textbox
properties data tab next to the Data type drop down list is a Format button.  
When you click on this you can designate that the format is a number and set
the number of decimal places.  Rounding will occur automatically for you.

> Hey all,
>     I have built an order form and i'm trying to round to the nearest cent.
[quoted text clipped - 10 lines]
>
> Michael
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.