[AccessD] Text Box Format

Yes and no.  Yes it doesn't make sense. And No he can edit it if he wants
to.  Users...gotta love 'em.

Rocky 

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

That doesn't make sense, Rocky.  If he wants it stored untruncated, he can't
edit a shorter version of it.

Charlotte Foust

On Sat, Jan 7, 2012 at 8:42 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

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