I doesn't change the state. The equals does that. The NOT simply asks
the question what is NOT male (female). Obviously it only works for
binary pairs. True/False, Male/Female, Yes/No, dead/alive, etc. granted
with the acception of True/False, you have to do some programming. T/F
works with NOT in the manner it does since all computers are based on
binary pairs that can be represented by TRUE/FALSE, YES/NO.
Steve said:
Thanks. that is cleaver. I thought that NOT was just for testing and did
not actually change the state.
Steve
:
Not does that, e.g.:
Me.[SomeControl].Visible = Not Me.[SomeControl].Visible
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Is there a built in function inAccess that will negate any binary
property?
Right now to flip/toggle/negate the state of say visable I have to
determine
what the current state is first. It would be nice to just flip it without
testing first.
Steve