Results 1 to 5 of 5
  1. #1
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200

    Disable Field?


    I have subform fields visible on my main form that I don't want the user to be able to edit. I know that the Locked property will accomplish this. However, I don't even want the user to be able to click in those text boxes to avoid any confusion. I want the "display only" text boxes to appear as such. I am now using the Enabled property to accomplish this. However, will this affect the data in the text boxes? I like how gives the text box a disabled feel, but does it affect data in any way? The data is entered on a different form, and I don't want that to be affected. Thanks.

  2. #2
    schwabe is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Location
    San Francisco Bay Area
    Posts
    50
    The data is not affected, you are disabling the element of the form.

  3. #3
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    So the Enabled property is specifically referring to the formatting of the text box...the data can still be edited on other forms?

  4. #4
    schwabe is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Location
    San Francisco Bay Area
    Posts
    50
    Yes, Ive just tried this a view days back.

  5. #5
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    Cool. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Disable field edit in form
    By cdilly17 in forum Forms
    Replies: 3
    Last Post: 07-12-2011, 10:13 AM
  2. Enable or Disable Field in Forum
    By lolos66666 in forum Forms
    Replies: 5
    Last Post: 03-13-2011, 05:30 PM
  3. Replies: 9
    Last Post: 12-17-2010, 11:44 AM
  4. Function to Enable/Disable Field
    By swalsh84 in forum Programming
    Replies: 5
    Last Post: 11-04-2010, 02:48 PM
  5. Replies: 5
    Last Post: 06-17-2009, 02:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums