Charlotte Foust
charlotte.foust at gmail.com
Mon Jan 9 23:17:31 CST 2012
Actually, I've dealt with this situation in VB.Net, but I'm not sure it's possible in Access since not all the textbox events are exposed. Charlotte Foust On Mon, Jan 9, 2012 at 9:16 PM, Charlotte Foust <charlotte.foust at gmail.com>wrote: > >>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 >> >> >> >> >