Input Mask

G

Guest

I have a field that is stored as Short Time. I have a combo box that is populated with the default values but the user is allowed to type something other than what is in the combo box. That is fine. The problem that I have is that if I put an input mask on the field when I select the value from the combo box it is giving me an error saying that the value is not allowed. The combo box is formatted for short time as well.
 
V

Van T. Dinh

Plse post the RowSource and the InputMask of your ComboBox.

Van T. Dinh
MVP (Access)


-----Original Message-----
I have a field that is stored as Short Time. I have a
combo box that is populated with the default values but
the user is allowed to type something other than what is
in the combo box. That is fine. The problem that I have is
that if I put an input mask on the field when I select the
value from the combo box it is giving me an error saying
that the value is not allowed. The combo box is formatted
for short time as well.
 
G

Guest

SELECT tbl_Times.Tim
FROM tbl_Time
WHERE (((tbl_Times.Shift)=[forms]![frm_timecardsummarymain2]![shift]) AND ((tbl_Times.Period)="start")
ORDER BY tbl_Times.Time

Input mask = 00:00;0;
 
V

Van T. Dinh

"Short Time" depends very much on your Regional Settings and can give 1
digit for the hour which is not acceptable with your InputMask.

If you use the InputMask "00:00", try the format "hh:nn".

Alternatively, try the InputMask "90:00" where the first digit is not
required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top