[AccessD] Decimal point with no places to the right

...Lesson #1 in how to survive as an independent Access developer. :)

William

--------------------------------------------------
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
Sent: Wednesday, February 04, 2009 6:06 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Decimal point with no places to the right

> I don't know.  Client requests it.  I do it. :)
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Wednesday, February 04, 2009 3:03 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Decimal point with no places to the right
>
> But Rocky, why would you show a decimal point at all if you aren't going 
> to
> show the decimal places?  That doesn't make any kind of sense to me.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: Wednesday, February 04, 2009 2:07 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Decimal point with no places to the right
>
> The field is a double but the user doesn't want the decimal places  to
> display.  The format example has the value and the mask as the two 
> arguments
> for the format.  But in this case the value is in a bound text box on a
> continuous form.  So I can't use the Format on the control source.  So not
> sure how to get the text box to show the whole number plus the decimal 
> point
> without the decimals fractions.
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Wednesday, February 04, 2009 11:01 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Decimal point with no places to the right
>
> ? format(111&,"0.#")
> 111.
>
> Too true. Works for integer types, though not sure if Rocky specified
> integers.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Wednesday, February 04, 2009 1:46 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Decimal point with no places to the right
>
> Hi Lambert
>
>> Your format string shows one decimal place (as I would expect it to)
>
> Yes, but none for an Integer - that I understood was the issue.
>
> /gustav
>
>>>> Lambert.Heenan at aig.com 04-02-2009 19:23 >>>
> Gustav? Your format string shows one decimal place (as I would expect it
> to) ? format(111.12,"0.#")
> 111.1
>
> This shows no decimal places...
> ? format(111.12,"0.")
> 111.
>
> Lambert
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>