I have a textbox on a form which is bound to a memo field. I am having some problems when there is a lot of text in the text box.
If there is very little text, you can add as much text as you would like and everything works fine.
If you have over 2000 characters already in the field, you cannot edit this textbox anymore without getting an error. Even if you edit the textbox to have less than 2000 characters, it will produce an error on save.
I read through the forums and someone said that the Rich Text Control would do what I need, but I am still getting the same errors with it, and when it takes the focus, the cursor does not move to the end of the field like the text box did.
Anyone have any suggestions, or is this just a limitation of Access that I will have to deal with?
If there is very little text, you can add as much text as you would like and everything works fine.
If you have over 2000 characters already in the field, you cannot edit this textbox anymore without getting an error. Even if you edit the textbox to have less than 2000 characters, it will produce an error on save.
I read through the forums and someone said that the Rich Text Control would do what I need, but I am still getting the same errors with it, and when it takes the focus, the cursor does not move to the end of the field like the text box did.
Anyone have any suggestions, or is this just a limitation of Access that I will have to deal with?