Results 1 to 4 of 4
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Enabled = "No" not working

    I have a couple text boxes that I have the "Enabled" property set to "No" for obvious reasons. However, some of them the user cannot click in, as expected, but the others still allow the user to click in. Both text boxes have formulas in their control sources. The only difference is I have conditional formatting set up on the text box that still allows the user to click in it. Any ideas as to how I can truly "lock" out the user from being able to click in the text box?

  2. #2
    Mclaren is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Feb 2010
    Location
    Johannesburg
    Posts
    164
    Have you set it using the fields properties, and via VB ?

  3. #3
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Conditional formatting overrides it unless you also make sure that the disabled button from conditional formatting is NOT depressed as well.

    See the screenshot below:


  4. #4
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Quote Originally Posted by boblarson View Post
    Conditional formatting overrides it unless you also make sure that the disabled button from conditional formatting is NOT depressed as well.
    Brilliant! Thank you!

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

Similar Threads

  1. "Or" not working in if statement
    By degras in forum Programming
    Replies: 0
    Last Post: 04-19-2011, 05:00 AM
  2. "And" stops functions from working
    By JimmD43 in forum Programming
    Replies: 5
    Last Post: 03-19-2011, 11:10 AM
  3. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM
  4. Report "WHERE" clause not working
    By rsearing in forum Reports
    Replies: 4
    Last Post: 05-26-2009, 02:07 PM
  5. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM

Tags for this Thread

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