Welcome to SPN

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

Sign Up Now!

Tables. How do I add properties in datasheet view

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

  1. Ferrari328

    Ferrari328
    Expand Collapse
    Guest

    I 'm supposed to be able to double click on the field name to go to edit mode
    and then type in the field name followed by the properties I want
    (text/Caption) but I can't get this to work.
     
  2. Loading...

    Similar Threads Forum Date
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Cold weather damages sugarcane, vegetables in Punjab (New Kerala) Breaking News Feb 1, 2008

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Ferrari328 wrote:
    > I 'm supposed to be able to double click on the field name to go to
    > edit mode and then type in the field name followed by the properties
    > I want (text/Caption) but I can't get this to work.


    Are you in a table, report, query or form and do you have it open in
    design mode?

    --
    Joseph Meehan

    Dia duit
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi.

    >I 'm supposed to be able to double click on the field name to go to edit
    >mode
    > and then type in the field name followed by the properties I want
    > (text/Caption) but I can't get this to work.


    If you're in Datasheet View in Access 2007, you can create a new field by
    double-clicking on "Add New Field," or edit any column name by
    double-clicking on it. If you aren't already on the Datasheet tab, select
    it. You'll see the combo box to select the data type in the middle of the
    UI ribbon, along with the "Format," "Unique," and "Is Required" items to
    customize this field.

    If you want to modify other properties, such as "Caption," then you'll have
    to put the table in Design View first, then select the new field name and
    press <F6> to jump to the Field Properties section to edit this field's
    properties. You'll have to save these changes before you go back to
    Datasheet View, because these changes aren't automatically saved as when you
    are in Datasheet View and editing those properties.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Ferrari328" <Ferrari328@discussions.microsoft.com> wrote in message
    news:4270F4CE-F516-4E61-AB84-1B8234874104@microsoft.com...
    >I 'm supposed to be able to double click on the field name to go to edit
    >mode
    > and then type in the field name followed by the properties I want
    > (text/Caption) but I can't get this to work.
     
  5. Ferrari328

    Ferrari328
    Expand Collapse
    Guest

    Joseph, I'm in New Object:table and are in datasheet view. I know how to do
    it in design mode. This is Access 2003.

    Thanks

    /Peter

    "Joseph Meehan" wrote:

    > Ferrari328 wrote:
    > > I 'm supposed to be able to double click on the field name to go to
    > > edit mode and then type in the field name followed by the properties
    > > I want (text/Caption) but I can't get this to work.

    >
    > Are you in a table, report, query or form and do you have it open in
    > design mode?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  6. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Peter.

    > I'm in New Object:table and are in datasheet view.

    <SNIP>
    > This is Access 2003.


    In versions before Access 2007, the only design change you can make in
    Datasheet View is to change the column name by double-clicking on it. To
    change any field properties, you have to change to Table Design View first.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Ferrari328" <Ferrari328@discussions.microsoft.com> wrote in message
    news:0BFBFA6E-5145-4BD0-A1B6-7FC1A52AB588@microsoft.com...
    > Joseph, I'm in New Object:table and are in datasheet view. I know how to
    > do
    > it in design mode. This is Access 2003.
    >
    > Thanks
    >
    > /Peter
    >
    > "Joseph Meehan" wrote:
    >
    >> Ferrari328 wrote:
    >> > I 'm supposed to be able to double click on the field name to go to
    >> > edit mode and then type in the field name followed by the properties
    >> > I want (text/Caption) but I can't get this to work.

    >>
    >> Are you in a table, report, query or form and do you have it open in
    >> design mode?
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit
    >>
    >>
    >>
     

Share This Page