We recently upsized an Access backend DB to SQL Server 2000 (front end in Access 2002) and have noticed some strange problems in our reports. A few of our fields which were memos in Access and are now ntext fields in SQL Server are being chopped off at 256 characters in a text box on a report. The query behind the report shows all of the characters, but on the report the field is chopped off. The strange thing is that we have multiple "memo" fields on a report (which are now ntext) and some of them actually display the full text, while others are chopped off. The CanGrow property is set to true on our fields. We got around the problem by doing a dlookup to get the data for the field and then the full text is displayed, however we'd rather not have to do that. Any ideas what the problem could be?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server ntext data type problem on Access report
- Thread starter BarbaraC
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question