[AccessD] Format During Edit

That doesn't help when you are actually in the textbox.  The full value is shown, regardless of 
the display fromat.


On 21 Jul 2011 at 15:20, Jim Lawrence wrote:

> ...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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>