lines of text...notes box

[Guest]

I have created a custom database for our marketing woman, I have designed the
table and layout...but I have created a Notes box for the user to enter
information into.

But the notes box is getting full and I would like to configure it so the
notes box can be unlimited rows or attach a text file to the table if
needed...I have read somewhere thatg the notes box is limited to 255 lines is
that right??

any help gratefully recieved but please be aware I dont know much about access

 

[Alan]

Hi Mister Bobzi,

Rather than defining the notes area as a Text field, make its properties a
Memo field.

A Memo field can hold up to 65,536 characters.

Alan

 

[Alan]

I also should have mentioned that the maximum size of a Text field is 255
CHARACTERS, not 255 LINES.

Alan

 

[Guest]

Thanks for the reply Alan, is there a way to attach a text file??

much appreciated