Welcome to SPN

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

Sign Up Now!

Changing global default value

Discussion in 'Information Technology' started by Skribo, Jul 28, 2006.

  1. Skribo

    Skribo
    Expand Collapse
    Guest

    I have many Number Colums, where the Default Value is always set to 0. I
    normally want no Default Value for Number Fields. Is it possible to have no
    Default Value as a Standard for Number Fields?

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    S Asia Thinking about the big move: The Sikh way of life changing in Khyber-Pakhtunkhwa Breaking News Mar 22, 2014
    Opinion Haanji's Quick Takes on a Changing World (September 23, 2013) Breaking News Sep 22, 2013
    Changing my last name to Kaur... Questions and Answers May 15, 2013
    Life-changing Inspirational Stories Mar 31, 2013
    USA Sikhism and the Changing Electoral Demographic Breaking News Mar 8, 2013

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Good question. If you are defining your tables via the
    interactive mode using the design view of a table, I know of
    no way -- you have to manually delete the DefaultValue.

    Normally, what I do is make one field and then copy that
    down, changing the fieldname and description, for the data
    types that are the same.

    Tables can be defined using code -- then you can make the
    default value whatever you want.

    Warm Regards,
    Crystal
    MVP Microsoft Access

    remote programming and training
    strive4peace2006 at yahoo.com
    *
    Have an awesome day ;)


    Skribo wrote:
    > I have many Number Colums, where the Default Value is always set to 0. I
    > normally want no Default Value for Number Fields. Is it possible to have no
    > Default Value as a Standard for Number Fields?
    >
    > Thanks
     

Share This Page