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 Chi, Jul 28, 2006.

Tags:
  1. Chi

    Chi
    Expand Collapse
    Guest

    Hi,

    The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    the date/ month/year in the table.

    Would you show me what is the input mask if I wanted to enter the year only?


    Thanks
    Chi
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 07:46:04 -0700, Chi wrote:

    > Hi,
    >
    > The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    > the date/ month/year in the table.
    >
    > Would you show me what is the input mask if I wanted to enter the year only?
    >
    > Thanks
    > Chi


    Sorry, a year is not a valid entry for a Date/Time datatype field.

    A valid date entry for a Date/Time field must include a month day and
    year.
    Access will guess (if you don't use an Input Mask) if you enter 1/5
    that you mean 1/5/2006 (the current year) or if you enter 7/2006 you
    mean 7/1/2006, but there is no way to simply enter 2006 as a valid
    date.

    If you only want the Year, than change the field datatype to Integer.

    Perhaps you should let us know why you want to do this, and someone
    will tell you how.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Chi

    Chi
    Expand Collapse
    Guest

    Thanks Fred,
    Your response is very helpful to me.

    Chi

    "fredg" wrote:

    > On Tue, 11 Jul 2006 07:46:04 -0700, Chi wrote:
    >
    > > Hi,
    > >
    > > The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    > > the date/ month/year in the table.
    > >
    > > Would you show me what is the input mask if I wanted to enter the year only?
    > >
    > > Thanks
    > > Chi

    >
    > Sorry, a year is not a valid entry for a Date/Time datatype field.
    >
    > A valid date entry for a Date/Time field must include a month day and
    > year.
    > Access will guess (if you don't use an Input Mask) if you enter 1/5
    > that you mean 1/5/2006 (the current year) or if you enter 7/2006 you
    > mean 7/1/2006, but there is no way to simply enter 2006 as a valid
    > date.
    >
    > If you only want the Year, than change the field datatype to Integer.
    >
    > Perhaps you should let us know why you want to do this, and someone
    > will tell you how.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     

Share This Page