Thread: variable
View Single Post
  #2  
Old October 18th 07, 01:14 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default variable

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