Welcome to SPN

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

Sign Up Now!

Display a field in a form that cannot be edited from the form.

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

  1. AdamCPTD

    AdamCPTD
    Expand Collapse
    Guest

    I have a form that I use to edit the data in a table that has 7 fields.
    I wish to have 3 of the fields viewable but not editable from the form.
    And I wish to be able to view and edit the other 4 fields from the form.
    I do not know how to do this, and I would appreciate any help.
    Thank you very much!

    Adam
     
  2. Loading...

    Similar Threads Forum Date
    Heritage Sikh Artwork On Display At Texas University History of Sikhism Mar 6, 2015
    UK Sikh Turbans on display at Bradford exhibition Breaking News Mar 1, 2014
    History Rare photographs’ display: Sikh community and culture presented in vibrant colour Punjab, Punjabi, Punjabiyat Dec 8, 2013
    Events Manuscripts on display at National Museum of Pakistan. History of Sikhism Mar 3, 2013
    Turban Display Uncovers Sikh History Sikh Youth Jun 7, 2011

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    AdamCPTD wrote:
    > I have a form that I use to edit the data in a table that has 7
    > fields. I wish to have 3 of the fields viewable but not editable from
    > the form. And I wish to be able to view and edit the other 4 fields
    > from the form. I do not know how to do this, and I would appreciate
    > any help.
    > Thank you very much!
    >
    > Adam


    Set the Locked property of the controls to Yes.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    For the fields you want to be read-only set the controls' Enabled property to
    False (No) and their Locked property to True (Yes). The controls will appear
    as normal but the user won't be able to edit them, or even move focus to them.

    Ken Sheridan
    Stafford, England

    "AdamCPTD" wrote:

    > I have a form that I use to edit the data in a table that has 7 fields.
    > I wish to have 3 of the fields viewable but not editable from the form.
    > And I wish to be able to view and edit the other 4 fields from the form.
    > I do not know how to do this, and I would appreciate any help.
    > Thank you very much!
    >
    > Adam
     

Share This Page