Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jan 16 16:52:09 CST 2012
Nope, smallint is the smallest signed integer. On 16 Jan 2012 at 12:08, jwcolby wrote: > Because of various issues with bit and Access I have always used int as the data type and -1 or 0 as > the default value. These can be bound directly to a check box (for example). > > Because the default int is a 32 bit number I was just looking to see if I could use a smaller data > type. A smallint is 2 bytes and includes negative values. A tinyint does not appear to allow -1. > Is there a signed byte datatype that I am not seeing? > > -- > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg