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