Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Input Mask

Discussion in 'Information Technology' started by Adam@nospam.com, Jul 28, 2006.

Tags:
  1. Adam@nospam.com

    Adam@nospam.com
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Andrew R

    Andrew R
    Expand Collapse
    Guest

    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@nospam.com wrote:
    > 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
     
  4. Adam@nospam.com

    Adam@nospam.com
    Expand Collapse
    Guest

    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.



    Andrew R wrote:

    > 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@nospam.com wrote:
    > > 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
     
  5. dongjianjun

    dongjianjun
    Expand Collapse
    Guest

    Adam@nospam.com 写é“:
    > 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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page