Access Text Field Question

[airbaal]

I am using VB6EE and am using the VisData program to create an Access database. I have a text field, but I guess Access limits text fields to 255 characters. If this is the case, how do you store text that is longer?

The only way I can think of doing it is having multiple fields and writing the first 255 characters to the first field, then the next 255 characters to the next field, etc. Then when I need that info from the database, I just set a text field on the layout to the first database text field, then add the second access field to the end, etc. until all fields have been added to the text box.

Is this how you experts do it? ;-)

Thanks...

Eric

[BryanJ]

Normally you would use a memo field and not a text field in Access. Is that any help?

[airbaal]

Yeah, that's what I needed. For some reason I was thinking a memo field wouldn't hold a lot of info when I was looking at the "size" of it ("0") compared to a text field's "255". But I was way off :-)

Thanks for the quick help.

Eric