vbCrLf with Memo data type

[nosferatu26]

Hi,

I have a memo field called History in my table that I use to store long text in as that record gets changed. Every time it does get changed I create a string with a time stamp and description of the change and use "vbCrLf" to format it to the next line so its displayed nicely in the form in a text box.

My problem is that it doesnt store enough characters. When I use "vbCrLf" does it take up a lot of characters? Because I can only get about 3 changes worth of text before the text gets truncated. If this is the case, is there an alternative way to go to a new line because its the easiest way to view the data. ideally I want each line to start off with the timestamp and that will indicate a different change.

Any help is appreciated as always with this!

 

[sneuberg]

Wouldn't it be easier just to store this data in a separate table?

 

[MarkK]

Some queries truncate memo fields at 255 characters, for instance, queries where you use the memo field in a GROUP BY clause.

Here's a thorough discussion of the possible causes. http://allenbrowne.com/ser-63.html

 

[nosferatu26]

thanks for the responses guys, I ended up making a new table and changing the text box to a list box.

 

[gemma-the-husky]

fwiw, I use this technique a fair bit, and never get truncated text.