Here is the syntax of my create table sql statement:<BR>"create table 1(ID INTEGER PRIMARY KEY, MemberID INTEGER NOT NULL UNIQUE, MemberName char(20) NOT NULL UNIQUE, Comment varchar(255) NOT NULL, Choice INTEGER NOT NULL);"<BR><BR>i was wondering if there was a way to set the Comment field to memo to allow it to store up to the 65,535 character limit. I tried to plug that into varchar(255) but it said that was too large, help me out? im running microsoft access 2000 (The above statement works as is now)