Inputting data

[Guest]

I am trying to find out if there is a way of inputting more data than the 255
characters designated by the Access programme. Any comments on this would be
gratefully received as this is a work based database.

 

[Dave]

I am trying to find out if there is a way of inputting more data than the 255
characters designated by the Access programme. Any comments on this would be
gratefully received as this is a work based database.

try a 'memo' data type instead of text. if that isn't big enough try an ole
object.

 

[John Vinson]

I am trying to find out if there is a way of inputting more data than the 255
characters designated by the Access programme. Any comments on this would be
gratefully received as this is a work based database.

A Text field in Access is limited to 255 bytes. But that's not the
only datatype you may use. A Memo type field is limited to 65536 bytes
if you're typing into it using the user interface, and to 2147483647
bytes if you load it programmatically; hopefully that will be big
enough (it's room for a couple of copies of the Encyclopedia
Brittanica... <g>)

John W. Vinson[MVP]