Dear John,
Thanks a lot. I am going to try.
Have a nice day,
Kevin
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar