Welcome to SPN

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

Sign Up Now!

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
     

Share This Page