how to store large amount of characters in MS Access Databas

Question

I have created one SMS Applciation.

In that application, i have one button called Send SMS when i click that button, from the database all Faculties gets the SMS.


When i send SMS error shows as follows;

the field is too small to accept the amount of data.

Database Design as follows in MS Access Database.

Field Name Datatype

Name Text
Mobileno Text
Message Text

In that Message Field Size is MAXIMUM Limit is 255 in MS Access Database.

Suppose in my applciation Message Field Size is extend to 255 characters, how can i able to solve that above problem (the field is too small to accept the amount of data.).


Please help me.

Regards,
Narasiman P.