Do you have the field set to Text, not a number?
--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)
"prodata" wrote in message
...
On May 20, 4:17 pm, "Douglas J. Steele"
wrote:
Read about the (optional) second section in the Help file (or
seehttp://msdn.microsoft.com/en-us/library/bb215691.aspx)
Thanks - that suggests that simply adding a semicolon and a zero to
the end of my input mask should do the trick. But sadly it doesn't
seem to.
So, if I set the input mask to 00:00:00;0 (penultimate character is a
semicolon) then 12:34:56 is still stored just as 123456 .
Using 00\:00\:00;0 gives no improvement.
What am I missing? Does the input mask need to be in quotes? Should
there be a space in there after the semicolon, or an additional
terminating semicolon? Or what?