AP1Check.VALUE = -1 returns Type Mismatch

[dmon000]

Why does this "AP1Check.VALUE = -1" return a "type mismatch" error?

It is part of an If statement. How do you test for the values of checkboxes?
I've tried "on" and "yes" and "true" and get a variable undefined error.

Thanks!!

 

[HarleyQuinn]

I don't know why you're getting the error, but you don't even need the =, you can just use

If AP1Check.Value Then...

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

What about this ?
If Me!AP1Check.Value = True Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

With Access bound controls, there's always the possibility of it being Null, therefore:

If Nz(AP1Check.Value,False) = True Then