Increase cell capacity to greater than 1024 characters

G

Guest

I assume you are refering to Excel - you need to post your question in an
Excel newsgroup. This newsgroup is for Micrsoft Access.

--Steve Huff
 
6

'69 Camaro

Hi, Patty.
Is it possible to display more than 1024 characters in a cell?

If you are referring to the maximum number of characters allowed in a cell
in Access's QBE design grid, then no. Jet can only allocate 1 KB to each of
these cells, due to the database file's architecture. There are a few
work-arounds, but the easiest is often just to use shorter names when
creating tables and fields. Sometimes the name of a query or the name of a
user-defined function can be substituted for the text that needs to be
placed in the query grid cell, but this depends upon what data set that the
query needs to retrieve.

If you are referring to a cell in a grid in some other application, we
cannot answer the question without knowing what application you are asking
about. And if that's the case, however, please post the question in an
appropriate newsgroup, since this one is dedicated to discussions of
Microsoft Access, the database application from the Microsoft Office
productivity suite.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top