Why does "true" import as -1 instead of 1?

M

MaureenG

When I imported a file with true in the data field access translated that to
-1, not 1. False was translated to 0, which makes sense.
 
G

GBA

-1 is the traditional value of a checked check box

not sure what the original logic on that was - just the way it is....

if you whip up a form; and use a checkbox or radio button for that
field...you will see that they are populated where -1 appears in the table....

so it works ok....
 

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

Similar Threads

transfer to excel 1
Error importing from Excel 4
Excel How to get output of the formula instead of True or false 1
Import only most recent file using FileSearch & LastModified 1
Import an outlook contact list into access 2007 0
Want to export "True" or "False" not 1 or 0 to tet file. 6
Import an Excel yes/no field 1
Complex Import Problem - PDF to XML to CSV to Access? 1

Top