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