Kevin-
If you don't mind "banker's" rounding, the CLng function should do the
trick. Use the format property to still display the two decimal places.
By "banker's" rounding I mean: A fraction that is exactly .5 is rounded to
the nearest even number. For example, 1.50 rounds to 2 and 4.50 rounds to
4.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of qingqing
Sent: Saturday, July 20, 2013 4:26 AM
To: MS Access Professionals
Subject: [MS_AccessPros] Round Numeric TextBox but keep ".00"
Dear All,
Please help. I want to round a Numeric TextBox but keep ".00". For example,
the Numeric TextBox is "52.55", the output expected: "53.00", instead of
"52.60". Is this possible?
Thanks in advance.
Best Regards,
Kevin
------------------------------------
Yahoo! Groups Links
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar