Re: Problem with large amount of characters in a VBA variant
- From: nartla <bruno.barral@xxxxxxxxxx>
- Date: Fri, 4 Jan 2008 01:44:02 -0800 (PST)
On 4 jan, 00:51, Bob Quintal <rquin...@xxxxxxxxxxxxx> wrote:
nartla <bruno.bar...@xxxxxxxxxx> wrote in
news:0a098301-faf3-4ef8-be89-4e1f0dc0c2c4
@u10g2000prn.googlegroups.co
m:
Hello,
I work on an app developped with Access/VBA and communicating with
a SQL Server database via ODBC.
My problem is that I have to manage a big string which can be 0 to
1024 characters long. The string is correctly stored in the Access
and SQL Server tables (Memo field for Access, and varchar(1024)
for SQL Server).
I also need to write this string in an Excel report created by the
application. For this purpose, I store the huge string in a
variant VBA variable, but when looking at the variant with the
debugger, I find that it has got only 255 characters (when the
string is 1024 characters long). In the Excel report, I also get
only the 255 first chars.
Is this a normal behaviour ? I searched the internet but I didn't
find information about the max string length that can be stored in
a variant in VBA ?
Thank you for your help.
See the Microsoft Knowledgebase article athttp://support.microsoft.com/kb/208801
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account fromhttp://www.teranews.com- Masquer le texte des messages précédents -
- Afficher le texte des messages précédents -
Thank you for your help.
.
- References:
- Problem with large amount of characters in a VBA variant
- From: nartla
- Re: Problem with large amount of characters in a VBA variant
- From: Bob Quintal
- Problem with large amount of characters in a VBA variant
- Prev by Date: Re: Consume Geodata web service
- Next by Date: Re: string is interperted literally
- Previous by thread: Re: Problem with large amount of characters in a VBA variant
- Next by thread: Access 2007 and Outlook Contacts
- Index(es):
Relevant Pages
|
