View Single Post
  #3  
Old May 20th, 2010, 05:20 PM posted to microsoft.public.access.forms
prodata
external usenet poster
 
Posts: 5
Default Input Mask - quick question

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?