[AccessD] Text Box Format

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