[AccessD] Format During Edit

...Or you could put the display format to ######.##.

Jim


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, July 21, 2011 2:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Format During Edit

Can you change the type of the underlying field to Currency rather than
Double?

-- 
Stuart

On 21 Jul 2011 at 14:41, Rocky Smolin wrote:

> Dear List:
> 
> I have a text box formatted to Currency - 2 decimal places.  The text
> box is editable and since some decimal numbers do not have an exact
> equivalent in binary, when I click into the box to edit it, I get a
> long string of decimal numbers.
> 
> For example, if the box has $3.25, when I click into it to edit it it
> displays 3.24999992735684.
> 
> The user would like it not to do this for obvious reasons but I can't
> seem to force the behavior I want which would be to display 3.25 for
> editing. Tried the input mask but no cigar.
> 
> What trick am I missing?
> 
> MTIA
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> 
> www.e-z-mrp.com <http://www.e-z-mrp.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