Access check box formatted yes/no exports to excel as true/false.

B

BobWattsi

Why does the access check box whcih has been formatted as yes/no transfer to
excel as true/false
 
P

Pieter Wijnen

because that's what they are
false = no = 0
true = yes = -1 (and also <> 0 ie not false)
format & value are different entyties

Pieter
 
Top