Results 1 to 4 of 4
  1. #1
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101

    Question Is it possible to change the color of a 'disabled' control?


    Currently, the 'disabled' controls are slightly grayed out and it is difficult to distinguish them from an enabled field. Is it possible to darken/change the color.

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    no - it isn't it is effectively a windows setting

    not possible with conditional formatting, but if you set the locked property to true as well as enabled to false then the control will look like a normal control but the user cannot change anything - then you can set colours as required

  3. #3
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101
    I am using conditional formatting to enable those controls when required. e.g. Control2 gets enabled when 'Yes' is selected in Control1. Is it possible to unlock a control in a similar way.

    EDIT: Locking a control is not as good as disabling it. I think i'll stick with disabling and accept this minor discomfort.

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    the lock property is not available through conditional formatting

    if you are not using a continuous form or datasheet you don't need to use conditional formatting, but can control through code.

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

Similar Threads

  1. change color of a buttons
    By azhar2006 in forum Forms
    Replies: 1
    Last Post: 10-29-2014, 06:15 AM
  2. VBA to change font color
    By data808 in forum Access
    Replies: 5
    Last Post: 10-23-2014, 11:10 AM
  3. Replies: 3
    Last Post: 05-30-2013, 08:03 AM
  4. Change Change FormHeader Color
    By burrina in forum Forms
    Replies: 4
    Last Post: 12-19-2012, 08:18 PM
  5. Text box change color
    By Ray67 in forum Forms
    Replies: 14
    Last Post: 11-19-2012, 04:06 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