Hi all,
Have been having many problems with memo fields truncating after about 512 characters. Having surfed for a while, a lot of the problem seems to stem from formatting characters residing in the memo text. For example, if you create a text box in a form, any thing you type into that box will be formatted in set size, font, etc.
When you run an update query to update the memo filed in the relevant record, it appears to transfer the data from the text box, including formatiing (Rich text). Hence, when you call this info back, it is truncated because memo fields can't deal with fromatting characters. Is there anyway you can prevent a text box from being formatted? Or can you make an update query only transfer plain text? Or is there some code that I can first strip the formatting out of the rich text (converting it to plain text) and then pass the data to the table? Or is there something else I should do?
Cheers,
Matt
Have been having many problems with memo fields truncating after about 512 characters. Having surfed for a while, a lot of the problem seems to stem from formatting characters residing in the memo text. For example, if you create a text box in a form, any thing you type into that box will be formatted in set size, font, etc.
When you run an update query to update the memo filed in the relevant record, it appears to transfer the data from the text box, including formatiing (Rich text). Hence, when you call this info back, it is truncated because memo fields can't deal with fromatting characters. Is there anyway you can prevent a text box from being formatted? Or can you make an update query only transfer plain text? Or is there some code that I can first strip the formatting out of the rich text (converting it to plain text) and then pass the data to the table? Or is there something else I should do?
Cheers,
Matt
