Thread: variable
View Single Post
  #3  
Old October 18th 07, 02:29 AM posted to microsoft.public.outlook.program_vba
Joel Allen
external usenet poster
 
Posts: 117
Default variable

Sorry Sue. I figured it out.

"Sue Mosher [MVP-Outlook]" wrote in message
...
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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Joel Allen" wrote in message
...
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




Ads