[AccessD] Text Box Format

Charlotte Foust charlotte.foust at gmail.com
Mon Jan 9 23:16:17 CST 2012


>>But that always seems so kludgey.

This for a client who wants to edit a number that doesn't actually exist in
the format he wants to see it???

Charlotte Foust
On Mon, Jan 9, 2012 at 8:29 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> The value is stored as a double.  It is displayed in a bound text box with
> two decimals (format - fixed, decimals - 2)
>
> So a number that might be stored as 1.357982 will display as 1.36.  But
> that
> value might have to be changed.  When he clicks into the bound text box to
> edit the value it displays 1.357982, which he says will be confusing to the
> user.  He wants it to display 1.36.
>
> I thought of the 'overlay' trick - clicks the bound text box - overlay
> becomes visible with 1.36.  After Update, the overlay box becomes invisible
> and the value in the overlay updates the record.
>
> But that always seems so kludgey.
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Monday, January 09, 2012 5:53 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Text Box Format
>
> So your client wants to store the value as a double but go back and
> overwrite the decimal fractions with whatever he types in?  Or is he going
> back to edit the integer?  One way would be to display the value in an
> unbound textbox, maybe on top of the actual value, and then store the
> result
> of the editing he does using code.
>
> Charlotte Foust
>
> On Mon, Jan 9, 2012 at 5:29 PM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>
> > Arthur:
> >
> > The box has to show hours to two decimal places and has to be edited
> > showing two decimal places.  But is stored as a Double - still hours
> > and decimal fractions. Changing the field type from numeric/double is
> > not practical.
> >
> > The input mask of 000.00 doesn't seem to work when editing.
> >
> > Any other ideas?
> >
> > Tks.
> >
> > R
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur
> > Fuller
> > Sent: Saturday, January 07, 2012 8:12 AM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Text Box Format
> >
> > Rocky,
> >
> > A simple way to do this is to use this as the input mask: 99:00;0;_
> >
> > However, this does not actually mean hundredths of a minute; rather,
> > it means minutes and seconds. For that reason, you can't enter more
> > than 60 seconds. The best approach i to forget about the date/time
> > field type, in my opinion. Change the field type to either numeric or
> > text. Either way, you can use the input mask above.
> >
> > HTH,
> > Arthur
> >
> > On Sat, Jan 7, 2012 at 10:41 AM, Rocky Smolin <rockysmolin at bchacc.com
> > >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
>
>
> >
> >
> > >
> >
> >
> >
> > --
> > Cell: 647.710.1314
> >
> > Prediction is difficult, especially of the future.
> >  -- Werner Heisenberg
> > --
> > 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
>
>
>


More information about the AccessD mailing list