Locale error "Type Mismatch"

G

Guillem

The following code :
dim xBoolean as boolean
dim rst as recordset
......
open rst etc..
.....
..filter = "[xBoolean]= " & xBoolean

when this is used in a w2000/msaccess2000 spanish environment, (maybe for
other languages too)

gives you "[xBoolean]=falso" not the correct one "[xBoolean]=false" and
..filter gives you a "Type Mismatch" error.

I would need to convert each boolean variable like :
..filter = "[xBoolean]= " & CInt(xBoolean ) which gives "[xBoolean]=0"

but is there something to configure in access to bypass this
"characteristique"?

Thanks a lot

Guillem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top