Text datatype not enough

[Ariharan]

I am creating a project for event in symposium with VB6.0 as front end and MSAccess as backend.In my project a particular field will have nearly 1000 to 5000 characters.But access do not allow this.Can anyone help me regarding this.

[FishVal]

I am creating a project for event in symposium with VB6.0 as front end and MSAccess as backend.In my project a particular field will have nearly 1000 to 5000 characters.But access do not allow this.Can anyone help me regarding this.

Hi, Ariharan.

Access Memo type field allows to store up to 65535 characters.