Combobox Control

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
 
P

Peter Yang [MSFT]

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.


--------------------
 
M

MA Harby

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
 
P

Peter Yang [MSFT]

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...
 
Top