I'm trying to create a small database to store code snippets.
The CodeSamples table has a field formatted as Long Text with Rich Text specified.
I loaded the code from a code module into a record. The code module, when exported has a file size of 216KB, so it's pretty big.
On the form bound to that table, a TextBox is bound to that field and configured as Rich Text. Everything should work fine, but the code is cut off short.
I found this on a Microsoft article:
Code:
Long Text
In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store
up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000
characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and
underline.
So the question is, is there any way around this limitation?
Thanks...
Update:
The articles say you should be able to store much more data in the Long Text field in the table than is being allowed in my database.
The text that is in that table field is 160,356 bytes. I get that by querying the table (Select Len(SampleCode) AS len From Samples).
At this point, I cannot add any more text to that field, even directly in the table and not using the form at all.
For some reason, if I edit the field data by tapping Shift-F2 and bringing up the edit window, I can remove text from the end of the field, but can't add any more text. Even if I remove several characters, save the field then go in to edit it again, I can't add any more text to it. What's going on here???