variable

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hi,

In my custom form code, I have global variable:

Dim varDocumentation

Further down in my code, I add things to the variable like this:

if Item.UserProperties("AirWater") = True then
varDocumentation = varDocumentation & "Air, Water, and Stuctural Reports" &
vbCrLf
end if

if Item.UserProperties("Impact") = True then
varDocumentation = varDocumentation & "Impact Safety Test Report" & vbCrLf
end if

If enough of the my if statements are true, I will get an error saying
"String too long". Any ideas on how to fix this?

Thanks,
Joel
 
What value does Len(varDocumentation) give you at that point? What's the purpose of that variable?

FYI, the newsgroup for custom form issues is microsoft.public.outlook.program_forms.
 
Sorry Sue. I figured it out.

What value does Len(varDocumentation) give you at that point? What's the
purpose of that variable?

FYI, the newsgroup for custom form issues is
microsoft.public.outlook.program_forms.
 
Of course. It's not really a solution, but found a valid work around.

Within a custom form, I had a subroutine that opened a Word document and
populated a Form Field with a large amount of date. It would give me a
string too long error. At first I thought it was the variable within my
custom form. But no, it was the Form field which can only handle so many
characters.

I ended up just making two form fields within Word, and strung them
together.

Joel

You might want to post your solution, to benefit people who read this thread
later and have a similar problem.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
Back
Top