Increase the size of memo field?

[dporrelli]

We are usinga memo field and it seems to have reached its capacity in size. User was typing away and "#Error" appeared, after a bit of digging, this appears to have reached its maximum size.

Is there anyway of increasing the field size?

 

[alvechurchdata]

I think the 64,000 character limit is a real one.Does it all have to go in the one memo field or is there any sensible way you can split the entries by topic or date?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dporrelli]

Yeah, at point of set-up, the system was not designed to hold so much data and was only supposed to be temp, but users decided to keep using it. I had done some digging and found that the size was limited, but I was hoping there might be a way around it, but thanks anyway.

 

[ReluctantDataGuy]

You might consider linking or embedding an MS Word OLE object.

Pro: You get full text formating functionality

Con: You lose the ability to search the text easily