how can we add large content(notes) in a cell of the table ?

[Ronak Moondra]

I have coloumn names as fund and fundnotes. The the fundnotes should be a
flexible cell where i can add lots of notes pertaining to each fund. Hence
the constraint should be removed of the fix characters in any given feild.

 

[KARL DEWEY]

You can use a Memo field. But you should use a one-to-many relationship and
DateTime tag each note.

 

[John W. Vinson]

On Mon, 8 Jun 2009 14:59:01 -0700, Ronak Moondra <Ronak

I have coloumn names as fund and fundnotes. The the fundnotes should be a
flexible cell where i can add lots of notes pertaining to each fund. Hence
the constraint should be removed of the fix characters in any given feild.

Changing the datatype of Fundnotes to Memo will allow up to 65536 characters
(actually more than a billion if you fill the field programmatically).

However, if there are multiple distinct notes, I'd really suggest removing the
fundnotes field from the table altogether; instead add a Notes *table* with
fields for the FundID, NoteDate (default value Now() if you wish to timestamp
the note), NoteAuthor (which could pick up the user's login id if you wish),
and a memo field for Note. This will allow you to keep each note distinct so
you can search or display them selectively.