Excalmation point in Date/Time input mask

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert - 11 May 2006 02:56 GMT

Does the ! work with Date/Time fields. I have a fields that is set as a
Date/Time fields - Short Time and I want it to fill in from right to left as
Access claims it will. I tried the example that MS gives (the phone number)
and it works great, but when I try to use it in this fields i get errors.

Field is BreakTime, set up as Date/Time. Format set to Short Time, Input
mask !9:99;;_

I type 30 into the field, expecting to get 0:30 but I get 3:00

Reply to this Message

PBsoft - 11 May 2006 09:51 GMT

> Field is BreakTime, set up as Date/Time. Format set to Short Time,
> Input mask !9:99;;_
>
> I type 30 into the field, expecting to get 0:30 but I get 3:00

I tried and noticed the problem is the Format property of the control.
I suppose the only solution is to use no specific format for the control
in your form and manipulate the value in the beforeudate event to suite your
display needs.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

Reply to this Message