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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top