gjblackford
Registered User.
- Local time
- Today, 06:30
- Joined
- Jul 17, 2006
- Messages
- 10
Hi,
I have an form with a large textbox (varchar 4000), stored in a table on SQLServer 2000, but when I access the data in access through the form when I have any reasonable amount of data on the form, I keep getting data coruption on the control.
for example
I create a record with about 1500 chracters in the text box, I save the record and when I come back to the record, all the data is not displayed and when I click in the control it gets even worse (some data can repeat it self).
Has anyone else had simular problems with access and large sql server fields, and if you have how have you resolved this issue?
Thanks,
Gavin,
I have an form with a large textbox (varchar 4000), stored in a table on SQLServer 2000, but when I access the data in access through the form when I have any reasonable amount of data on the form, I keep getting data coruption on the control.
for example
I create a record with about 1500 chracters in the text box, I save the record and when I come back to the record, all the data is not displayed and when I click in the control it gets even worse (some data can repeat it self).
Has anyone else had simular problems with access and large sql server fields, and if you have how have you resolved this issue?
Thanks,
Gavin,
