Data Control: Recordsource-Property restricted to 255 Characters ?? 
Author Message
 Data Control: Recordsource-Property restricted to 255 Characters ??

The Recordsource-Property of the data control seems to be restricted to
255 characters although it is defined as "string".

Does anybody know where this is documented definitely?


Dim rs as Recordset
' Create Recordset here with SQL-statement longer than 255 characters
Data1.Recordset = rs
' This is ok, but if you e.g then refresh the control
' SQL-statement fails because it is obviously cut at length 255

I was looking for the "error" more than 2 hours because my SQL-statement
was cut exactly before the "HAVING"-component of the SQL-string by chance,
so no error occurred but only the result was wrong  :-(

(Tools: VB5/sp3 Enterpr. Ed, WinNT4.0)

 Joe Broethaler

 Institute of Public Finance        
 and Infrastructure Policy,
 University of Technology Vienna    

Mon, 05 Feb 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Data in varchar(2000) field truncated at 255 characters on report

2. Winsock INET_ADDR returns INADDR_NONE for

3. RecordSource 255 char limit workaround?

4. Setting a recordset object to a data control's recordsource property

5. Passing Params To SQL Server Stored Procs On ADO Data Control RecordSource Property Page

6. variable>255 characters?

7. SQL Strings appear to truncate to 255 characters

8. Cannot store > 255 characters in Memo field

9. Help! DoCmd.ApplyFilter cuts String after 255 characters

10. 255 SQL character limit

11. 255 character limit on SQL statements

12. Exporting Notes Truncates to 255 Characters


Powered by phpBB® Forum Software