What data type could I use in my access database that can hold very long texts. By default, each cell in Access tables can only contain up to 255 characters. Is there any way to extend this to any length I want?

Recommended Answers

It is a Text datatype.

Jump to Post

All 4 Replies

It is a Text datatype.

But Text data type can only accept 255 characters... What should I do? Anyone please?

Sorry! It's a Memo field type.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.