[AccessD] Text Box Format

That's a problem because the user wants the whole fraction stored
untruncated.  Otherwise when they restart the timer which show
hours:minutes:seconds it jumps to a different time. 

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, January 07, 2012 7:51 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Text Box Format

My first idea would be to truncate the value in the Before Update event so
that you never store the extra places.

--
Stuart

On 7 Jan 2012 at 7:41, Rocky Smolin wrote:

> Dear List:
>  
> I have a text box which is bound to a field which stores elapsed time 
> so there's usually a string of decimals in the table.
>  
> The user wants to see the time to the nearest hundredth of a minutes.  
> No problem Format Fixed, decimal places 2, 1.23456 displays as 1.23.
>  
> But when he goes to edit the field it displays 1.23456 making editing 
> difficult.  He wants to still see 1.23 in the field when he clicks in 
> to edit (and is willing to lose the fraction past 2 decimal places 
> when editing).
>  
> Is there a way to control that?
>  
> 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/>
> Skype: rocky.smolin
>  
> --
> 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