Input Mask

[Adam]

Hi,

I'm trying to use an Input Mask on a field on a form, I want it to be
like dd/mm/yy, so have used 99/99/00;0;_

Everytime I click out of Input Mask in the form properties, it removes
the "/" seperators from my input mask.

Anyone know why and how I can stop it from doing this?

Thank you

Adam

 

[Andrew R]

Hi

I have a few thoughts, maybe one of them will help...

Firstly, why are you using an input mask to allow data only in date
format? If the data type of the underlying field in the table is set to
Date/Time then this will do a lot of the work of only allowing valid
data anyway, which is what the input mask is designed to achieve. I say
it will do a lot of the work; it will, of course, allow times as well
as dates, so that may be a problem, I don't know...

My second thought is that rather than using 9s you should probably use
0s.This means that the date would have to be entered as 04/07/06 rather
than allowing 4/7/06 or even 4/ /06, which would be allowed by your
current input mask, if not by the underlying data type (assuming again
that you've set it to date, not something like Text)

Aside from that, to answer your question specifically, I cannot see why
the / symbols would be removed - are you sure you're not accidentally
writing the input mask in another property?

HTH

Andrew

 

[Adam]

Hi

I wanted to use an InputMask on the date field because I work with some
total idiots. If there's any possible way for them to make a mistake or
hash of something, then they find it.

I've got to work and it's working fine now, so it must be something
with my home computer.

I've replaced the 9 with 0 in the InputMask, thank you for the advice.

 

[dongjianjun]

(e-mail address removed) 写é“:

Hi,

I'm trying to use an Input Mask on a field on a form, I want it to be
like dd/mm/yy, so have used 99/99/00;0;_

Everytime I click out of Input Mask in the form properties, it removes
the "/" seperators from my input mask.

Anyone know why and how I can stop it from doing this?

Thank you

Adam

dongjianjun