Thread: JOIN an array
View Single Post
  #2 (permalink)  
Old November 9th, 2004, 05:38 AM
madhukp madhukp is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Cochin, Kerala, India.
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp
Default

I could not understand your problem fully. What do you mean by "sub-item" ? May I know what is the object frmPricingsubform![Description] ? Is it a text box ? Are there a number of text boxes of this name in a form ?

I think you may have to use a control array of textboxes of same name. You can then join the texts as below.

strFinalString=Description(0).Text & Description(1).Text & .... & Description(n).Text

You have to have the number of textboxes in a variable say iNumTextboxes. Then the following script will do it.

For iLoop=0 to iNumTextboxes-1
    strFinalString=strFinalString & Description(iLoop).Text
Next