Hale, Jim
jim.hale at fleetpride.com
Wed May 14 13:03:48 CDT 2003
You sound like my wife. :-) Jim -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Wednesday, May 14, 2003 10:49 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Very interesting quirk in table design... 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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030514/158f5c49/attachment-0001.html>