ConsitionalFormats clears block

[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

 

[Allen Browne]

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

 

[Stephen Lebans]

Allen I have found the only way around this bug/feature is to set the
FormatCOnditions object programmatically instead of via the CF GUI. The
sample MDB on my site shows how to do this.
http://www.lebans.com/conditionalformatting.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.