[AccessD] Text Box Format

Rocky Smolin rockysmolin at bchacc.com
Mon Jan 9 23:31:30 CST 2012


Well...yeah. :)

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, January 09, 2012 9:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Text Box Format

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