Hi all, just wondering if anyone knows this off the top of their head, i am creating a table in an access database using the CREATE TABLE command, normally if i want to create a table and have a field in it that contains text i do something like CREATE TABLE text (255) null something along those lines, what must i substitute for "text" to create a yes/no field with the tickbox? i have tried "logical" which creates the field but gives me no tick box many thanks EDIT: or can anyone tell me what they would google to find such information? im not 100% sure what i am looking for so i am struggling to find it thank you