Access Field Sizes

I am configuring a database, where I am needing to fill in fields that are greater than 255 characters - Closer to several THOUSAND characters...

Can something be constructed to have all data filled in on one field, and if it goes over 255 characters, will automatically cut off at 255 chars and move the remaining characters to another field, and if that one is greater than 255, move the remaining to a third field, and so on....

Or better yet, is there a way to remove the 255 character limitation?

I am using Access 2003.

Thanks for any help!