[AccessD] Decimal point with no places to the right

Hi Rocky

No, that wouldn't work for negative numbers. While that could be fixed(!):

=Str(Fix(fldMyField)) & "."

it would round down/off (towards zero) where the format expression will round to nearest integer.
Also, it would always return a trailing dot even if your decimal point is something else (like most places outside the US).

/gustav


>>> rockysmolin at bchacc.com 05-02-2009 01:22 >>>
=str(int(fldMyField)) & "."? 


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 Bobby Heid
Sent: Wednesday, February 04, 2009 4:19 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Decimal point with no places to the right

One way would be to convert it to a string and then lop off the decimal
digits.

Bobby

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

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