ACCESS FEED: RE: [MS_AccessPros] Re: Round Numeric TextBox but keep ".00"

Senin, 22 Juli 2013

RE: [MS_AccessPros] Re: Round Numeric TextBox but keep ".00"

Kevin-

Set the Format property of the text box to something like $90.00 - that
should display the "rounded" integer number with two decimal places.

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 qingqinga
Sent: Monday, July 22, 2013 12:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Round Numeric TextBox but keep ".00"

Dear John,
Actually I want the result displaying like "4.00", instead of "4.50". Is tha
possible? Let me explain it, if I just put "4" there, then the user won't
have a feeling of somthing to do with money. Thanks.
Best Regards,
Kevin

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...>
wrote:
>
> 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
>

------------------------------------

Yahoo! Groups Links