[AccessD] Text Box Format

Rocky Smolin rockysmolin at bchacc.com
Sat Jan 7 09:41:45 CST 2012


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
 


More information about the AccessD mailing list