chuckcoleman
Registered User.
- Local time
- Today, 01:51
- Joined
- Aug 20, 2010
- Messages
- 363
Hi, I have a form called "Detail Form" with a text box on it. The underlying field is a Long Text. The text box is formatted as Rich Text. If I double click on the text in the text box, it opens a popup form that is based on the same table as the previous form that holds the text box. The popup form has a text box on it that is simply larger in size than the one on the Detail Form to facilitate easier editing/entry. When I add text to the popup form, in most cases as soon as I close the popup, the Detail From text box is updated. It appears that when there is a lot of text in that field, it doesn't update the Detail Form's text box even though the popup is based on the same table as the Detail Form. I added to the popup vba code to tell me the number of characters in the text box in the popup form. The MsgBox indicates 2,908 characters which I believe is much smaller than the limitation of that field, (Long Text type). If I try a different record on the Detail Form where the text box has a smaller number of characters, it works. For instance, on a record where the text box has 1,869 characters, it works fine and updates the underlying field.
I've tried adding Modal to the popup form but it still doesn't update the field if the number of characters is 2,908. I haven't tried guessing at what size below that makes it work. Note: when the popup form closes it does a Recalc of the text box on the Detail Form.
Any ideas?
I've tried adding Modal to the popup form but it still doesn't update the field if the number of characters is 2,908. I haven't tried guessing at what size below that makes it work. Note: when the popup form closes it does a Recalc of the text box on the Detail Form.
Any ideas?