Problems with Memo field on unbound form

[mjake13]

OK, after reading through as many threads as I could, here's my problem:

In my current report writing system, I use a bound form with a memo field. Problems arose if more than one person had accessed that form while it was still open by the original user, thus leading to write conflicts or errors.

My question is this, I have made an unbound form with this memo field and I'm trying to figure out the best way to save it. I have found that the memo field is being cut off after so many characters. Is there a workaround to this or is using the memo field a bad idea?

Also what would be the best recommendation to save the data in this unbound form? I currently have written VBA code to insert the values into their respective fields in a table. This worked for all of the text fields, except the memo field, which got cut off.

Any help would be appreciated!

 

[THWatson]

mjake13
The maximum number of characters in a Memo field can be 65535 characters, whereas the maximum number of characters in a Text field can be 255. If you don't need more than 255 you might try changing the data type to Text. (Memo fields seem to have some quirks.)

Tom