maximum text characters of a file

[Guest]

Can you expand the maximum text characters of a file to over 255? I have
passages of text which I want to organize, some of which can be lengthy while
others are short. I figure a database would be the easiest way since there
may be multiple subject headings to a single file. If Access can't do it,
does anybody know of an alternate program which would be better?

 

[Dirk Goldgar]

Can you expand the maximum text characters of a file to over 255? I
have passages of text which I want to organize, some of which can be
lengthy while others are short. I figure a database would be the
easiest way since there may be multiple subject headings to a single
file. If Access can't do it, does anybody know of an alternate
program which would be better?

A field of type Text is limited to 255 characters, but a field of type
Memo is limited only by the maximum size of the database file. Entering
data in a memo field by way of a text box limits it to (I think) 65,535
characters, but that's still a lot more than you're likely to need.

 

[david epsom dot com dot au]

Some of the indexing, sorting, grouping, and updating features of
Access are limited to 255 characters, which might not be the case
for an alternate program.

But if you are looking for a better program, I am afraid you are
asking in the wrong place :~). We don't necessarily know much about
other programs.

However, time spent in Access may not be totally lost, even if you
change programs later - you may be able to suck any text you have
entered in the database straight into the new system.

For example, if you decide to use text indexing services in SQL Server
or AskSam, you should be able to copy straight across.

(david)