255 fied size inadequate

[Skylight Steve]

I need to be able to place much more than 255 characters into a field in
ACCESS. Is there some way to have a field linked to a WORD file but look to
the user as if they are inputting the data into an ACCESS form field? Or is
there a better way?

 

[Jerry Whittle]

Memo fields can hold up to 64K characters (or even more if you work at it).
However memo fields have some weaknesses such as being more difficult to
export; not being able to sort easily; no indexing; very slow when searching;
and are know to increase the possibility of database corruption.

 

[John W. Vinson]

On Fri, 24 Oct 2008 10:35:06 -0700, Skylight Steve <Skylight

I need to be able to place much more than 255 characters into a field in
ACCESS. Is there some way to have a field linked to a WORD file but look to
the user as if they are inputting the data into an ACCESS form field? Or is
there a better way?

Change the datatype from Text to Memo. That will give you up to a billion
bytes if you need it (65536 bytes with no effort at all).