Input Mask

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Click to expand...
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.
 
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;
 
"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.
 
Back
Top