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

Senin, 22 Juli 2013

[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
>