Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Truncated data

Author  Topic 

Pinto
Aged Yak Warrior

590 Posts

Posted - 2005-06-23 : 04:10:29
I am displaying data from a SQL table in an Access report. The report is based on an Access query which filters the SQL data. I am using DLookUp to display one field which is nvarchar(2000)in Sql but it truncates the data at both ends in the report.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-06-23 : 04:29:03
quote:
Originally posted by Pinto

I am displaying data from a SQL table in an Access report. The report is based on an Access query which filters the SQL data. I am using DLookUp to display one field which is nvarchar(2000)in Sql but it truncates the data at both ends in the report.



does adjusting the size of the bounded control solve your problem?

what do you mean by "both ends in the report"? physical?

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -