data entry with more than 255 words

[cihow81]

Hi, if i have to input a entry that have more than 255 words, but my table could only handle 255 words, so how do i go about it... pls advise, thanks...

 

[john471]

Are you referring to the 255 character limit of a text field ?

If so, then you might consider using a Memo field instead.

HTH

Regards

John.

 

[WayneRyan]

cihow,

When you say 255 words, do you mean 255 fields? That is way too many fields
for a table to have. You must have repeating groups of something to get the
numbers up that high. If you have something like Name1, Name2, Name3 ...
then those should be split into another table.

Wayne

 

[Doctor Kronenbo]

You can't have more than 255 characters per text field - best thing to do is just add another field if you require additional data entry