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