ConsitionalFormats clears block

  • Thread starter Thread starter Andrew Ofthesong
  • Start date Start date
A

Andrew Ofthesong

hi, i have a textbox with "active"=false; "Blocked"=true

whenever i create a conditiona format for that textbox, now i can enter the
textbox, select its contents, etc
 
Not sure what you mean by these properties.
Did you mean "Enabled" is false and "Locked" is true?
That would be the usual approach for keeping a user out.

There is indeed a bug in the implementation of conditional formatting that
allows a disabled control to receive focus under certain conditions. You
could try setting focus to another control in the disabled control's
GotFocus event, but I can't recall if it was effective. It's fairly easy to
crash Access by triggering a sequence that causes the conditionally
formatted controls to reformat, which retriggers your code, which causes
them to reformat again, which ...
 
Back
Top