[AccessD] Very interesting quirk in table design...

Gustav Brock gustav at cactus.dk
Wed May 14 10:49:23 CDT 2003


Hi Charlotte

Would that be for Not Yes and Not No?

(sorry)

/gustav


> Is the additional byte for the sign?

> Charlotte Foust

> -----Original Message-----
> From: Henry Simpson [mailto:hsimpson88 at hotmail.com] 
> Sent: Wednesday, May 14, 2003 6:30 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Very interesting quirk in table design...


> Curious that in Access 97, and I'll assume subsequent versions as well,
> a yes/no field stores 2 bytes for each entry.  Using a numeric value
> like a byte requires half the storage and gives you 8 states that
> equate to 8 two state fields or 4 four state fields or whatever
> other combination of 8 bits you devise, plus null.  I've never
> understood why the yes/no field requires two bytes and use bytes for
> boolean fields for the increased flexibility.
> Form logic doesn't seem to require any change if you simply use one byte
> field for each field requiring a boolean display.



More information about the AccessD mailing list