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