Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenate several strings

Status
Not open for further replies.

loydlr

Technical User
Mar 4, 2002
34
RU
I am trying to concatenate several strings into one in a report. It seems fairly simple and works well. The problem is that my code concatenates the necessary strings in the first record and supplies this same string to every record.

Private Sub Report_Activate()

Dim strSize, strType as String
Dim strPaint, strStripes As String

strSize = Me.txtSize
strType = Me.txtType
strPaint = Me.txtPaint
strStripes = Me.txtPinStripe

Me.txtModel = strSize & " " & " " & strType
Me.txtPnt = strPaint & " " & "w/ " & strStripes

End Sub

I placed the unbound text boxes "txtModel" and "txtPnt" in the detail section. I am trying to concatenate the text boxes for every record so that each instance of txtModel and txtPnt are unique to it's record. Any suggestions would be greatly appreciated.

Thanks,
Loyd
 
Hi,
These belong in the On Format event in the Detail section of your report.
HTH,
Randy Smith
California Teachers Association
 
Works like a charm. Thanks a bunch Randy. You have saved me countless hours of digging to find that answer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top