Seasons' greetings to the list, Using an Access 2000 database... When creating Tables with SQL, I know how to set a column's datatype to variable length text, but this only gives me a max of 255 characters - columnname varchar(255). Access has a 'memo' datatype, is there a way to create it with SQL? Thanks. -marc