By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

Excalmation point in Date/Time input mask

P: n/a
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

May 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> 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
May 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.