[AccessD] Decimal point with no places to the right

Hi Rocky

I tried this in A2007 as well, and it works perfectly. 

Did you remove the input mask? And you apply the format to the textbox? The source _must_ be left as is.
Else something weird must be going on at your end.

/gustav

>>> rockysmolin at bchacc.com 04-02-2009 23:06 >>>
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