Re: Access Bound Checkbox error for boolean field

Randy,

Under the Advance Options for the ODBC Drivers do you have 'Bools as Char'
Checked? If so uncheck it.

Ryan

> -----Original Message-----
> From: Randall Perry [mailto:rgp(at)systame(dot)com]
> Sent: Tuesday, October 30, 2001 1:16 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Access Bound Checkbox error for boolean field
>
>
> on 10/29/01 8:59 PM, Randall Perry at rgp(at)systame(dot)com wrote:
>
> > Am getting the following error with a bound checkbox field
> in Access 2000
> > when I try to toggle it:
> >
> > 'field is too small to accept the amount of data you are
> trying to enter'
> >
> > Anyone know the fix?
> >
> Actually, it's Access XP, and the reason for the error is
> that my PgSQL
> boolean field is being mapped to a TEXT field in Access.
>
> How do I fix this? Or do I?
>
>
> --
> Randy Perry
> sysTame
> Mac Consulting/Sales
>
> phn 561.589.6449
> mobile email help(at)systame(dot)com
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>