iam working in access.and i imported a table from warehouse,and in that table,year field is a text field with 02 field size.numbers r like 03,04,02 .and i want them to be 2003,2004,2002,like that.so i i made field size to 50 .but its saying that microsoft cant change the datatype.ther is'nt enough space for disk.i tried to do it by even going to tools,options,tables/queries and changed the defalut to 50 once and again 255.but still its not working.atlast i kept only 4 also for field size but stil its aying disk out of space.
how can i change my data field size?
help me out with this problem.