Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Where was I when Enabled property definition changed?

    Once upon a time, one could use the Enabled and Locked property to control whether or not the user could click on a field or enter data into it.

    If Enabled=True, Locked= false: Field could get focus and user could change value.
    If Enabled=False, Locked=False: Field could not get focus, and field was dimmed.
    if enabled=True, Locked=True: Field could get focus, but user couldn't change value.
    If enabled=False, Locked=True: Field could not get focus, but it wasn't dimmed.

    Now, however, there appears to be an exception to all of this. If the field has a conditional format, and that condition is currently met, then the Enabled property doesn't have the same meaning! Basically, even though the Enabled property is False (the 2nd situation above), the field can still get the Focus, it is not dimmed, and it can even be changed!

    Here is the Help message displayed if one taps F1 in the Enabled Property in Design Mode:

    "You can use the Enabled property to set or return the status of the conditional format in the FormatCondition object. Read/write Boolean."

    Huh?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I believe that change happened in Access 2007 - the actual change was to allow conditional formatting to set the enabled property on a control on a row by row basis in a continuous form. Others may be able to shed more light on it than I can.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Quote Originally Posted by WendellB View Post
    I believe that change happened in Access 2007 - the actual change was to allow conditional formatting to set the enabled property on a control on a row by row basis in a continuous form. Others may be able to shed more light on it than I can.
    It seems to have happened as early as Access 2003. I think I just never noticed it because I just never happened to set a control's Enabled property to No when it was actually using a Conditional Format.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •