Thread: Access and field sizes

Access and field sizes

From
Andrew Perrin - Demography
Date:
Greetings-

I'm in the process of porting a database from Access to postgres, and have
run into a snag.  The snag involves boolean fields using checkboxes in
Access forms; they always return a useless Microsoftish error:

The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data. 

This happens when a checkbox is clicked to set a boolean value to True,
but not when it is clicked to set the value back to False.

Does anyone have any experience or idea where to go with this?

Thanks-
Andy Perrin

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography    -    University of California at Berkeley
2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199