[AccessD] Format During Edit

That worked.  Thanks, Stuart.

Rocky
 

-----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