[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

-----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 1:19 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Decimal point with no places to the right

Gustav:

Didn't show the decimal point.  What am I doing wrong?  I tried it both in the Format property and the input mask.


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 Gustav Brock
Sent: Wednesday, February 04, 2009 9:01 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Decimal point with no places to the right

Hi Rocky

You can use a format string of:

  "0.#"

/gustav

>>> rockysmolin at bchacc.com 04-02-2009 17:28 >>>
Dear List:

Is it possible to format a number in a bound text box with zero decimal places to the right of the decimal point but still display the decimal point?

MTIA

Rocky