[AccessD] Text Box Format

Darryl Collins darryl at whittleconsulting.com.au
Mon Jan 9 23:27:13 CST 2012


Are you able to pass a rounded value to an unbound text box for the user to edit, and then write the edited value back into the table upon accept/close.  Of course this would mean you only get back the value to 2 decimal places after editing, which may not be what you want at all.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, 10 January 2012 3:29 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Text Box Format

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