adding extra field (access 2007)

[nokia123]

i have a database of 100 people which include fields like "name,address,mobile,country...etc etc " .using vb-access integration ,i have pulled all these fields onto a form. things are going fine.. its displaying all the data as it should.
but now i have to add one more field called "character" in the same database and this new field ,for every people, contains long string and access-2007 is denying me to fill cells with this long string.

how do i do this in a robust way.so that when i pull the data of any person ,the character associated with this person also get displayed.

thanx

 

[jmcilhinney]

Are you saying that you want to add a column or you already have added a column? Your post is very unclear on this. If you've already added the column, how exactly did you do it? If you haven't then how can the database be rejecting your data?

 

[nokia123]

yes, i want to add an column "Character " . but the problem is in the character column , the data is to feed is a large string about 150 letters long.
and access-2007 is not allowing me to feed this large number of string in the cells.

 

[jmcilhinney]

If Access is not accepting the data then you must have already added a column. I already asked that you tell us what you did if you already added a column. Is there a particular reason that you won't provide the information already requested?

 

[ss7thirty]

255 is the maximum amount of characters in an access text field.

 

[nokia123]

Thank you, Making Field as Memo ,resolved my problem