Yes, this is standard in Access/Jet.
Never cared to look into exactly why, but think of it as a one bit signed number. Since the leading bit is always 1, the value is always negative. Hence "-1". Just test for "<> 0" or "=0" instead, to make things clearer. In vba, any non-zero value is "true".