Combobox Control

  • Thread starter Thread starter MA Harby
  • Start date Start date
M

MA Harby

Hi Group
Does anyone know what the internal data size for the RowSource property is,
specifically when using a RowSourceType of Table/View/StoredProc.

The results from the Stored Procedure I am using seem to be truncating.

Thanks


MA Harby
Nottingham. UK
 
Hello MA,

Based on my research, RowSource is a String type value which points to the
actual string characters. The maximum string lenght supposes to be 32767
characters

http://www.romanpress.com/Articles/Strings_R/Strings.htm

http://msdn2.microsoft.com/en-us/library/wdzat713.aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
 
Thanks for that Peter
The problem I have is that I am using the .GetString method of an
ado.recordset object to query a table and return a preformatted string
compatible with a .RowSource property. Reading the VB documentation, it
states "A string can contain from 0 to approximately 2 billion (2 ^ 31)
Unicode characters." when defined as purely a String datatype, this is
obviously not then compatible with the RowSource property and hence gets
truncated when the 32767 character limit has been reached.

Mark Harby
Nottingham. UK
 
Hello Mark,

Welcome! :-)

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
From: "MA Harby" <[email protected]>
References: <#[email protected]>
Click to expand...
 
Back
Top