Where was I when Enabled property definition changed?

Topic

New Reply

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.”

[/B][/B]Huh?

Reply | Quote

Replies

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.

Reply | Quote