Member Avatar for markdean.expres

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?

  • 2 Contributors
  • 4 Replies
  • 95 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by markdean.expres
Member Avatar for kvprajapati

It is a Text datatype.

Member Avatar for markdean.expres

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

Member Avatar for kvprajapati

Sorry! It's a Memo field type.

Be a part of the DaniWeb community

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