Excalmation point in Date/Time input mask

[Robert]

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

[PBsoft]

> 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