Memo field limitations

[davesmith202]

I've read that memo fields can contain 65,535 characters, but I have data I want to store occasionally which is more like 64,000 lines! I cut and paste the data in there normally. I've read that it can hold up to 1 gig programmatically in a memo field.

How can I get around this limitation? Can I use the programmable approach somehow? What about using a vb6 control in my Forms. Is this possible?

The purests will be saying to store the data in a table. I can hear it already. But this is a route I don't want to go down, since all the code is already done, I often do quick edits of the data, pasting in chunks half the way down my lists and so on. The only limitation I've got is very occasionally, I cannot store a huge list in this memo field.

Thanks,

Dave

 

[wazz]

i think i read something about that in a recent thread (last month or two). search for 'memo' posts, possibly a post by datAdrenaline but not sure.

 

[davesmith202]

I've read that post but doesn't really tell me anything I don't know. What about a richtextbox? Would that let me paste in more than just a memo field, even if it links to the same field?

 

[gemma-the-husky]

the only way you are going to do this is with some hard coding

perhaps instead of storing the text, store a link to a disk file, and open that wityh notepad or something.

as far as a dbs is concerned 64K characters is a lot of stuff for a text field

 

[CyberLynx]

Over 64000 lines of Data into a single field of a record.

I personally would never consider such a thing. If large blocks of data such as this are to be stored, I would be doing it into Text Files and then merely have the path to that file stored in table. Read in the File when needed.

I personally wouldn't even put 1K into a memo field....but...that's just my opinion.

.