Inputting data

K

kathsnorris

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.
 
D

Dave

kathsnorris said:
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.
Click to expand...

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

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.
Click to expand...

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]
 
Top