Any idea why this code for Crystal Reports won't work with Strings?

[Thom]

Do any of the Crystal Report gurus know why this works with an Integer but NOT when it's a String?

Dim TestNum As Integer
SurNum = 1
Dim TestName As String
SurName = "This is Report Style # 2!"

With Report1
.CrystalReport1.DataFiles(0) = App.Path & "\test.mdb"
.CrystalReport1.ReportFileName = "\latest.rpt"
.CrystalReport1.Formulas(0) = "startcode = " & TestNum
.CrystalReport1.Action = 1
End With

This will work with TestNum but I get "Error in Formula" if I try it with TestName(a string). Any ideas why? What I'm trying to do is pass the Test Name as a Page Header to the Crystal Report report? ANY help would be greatly appreciated!

[BruceG]

When you want to use report style #2, try this syntax:

.CrystalReport1.Formulas(0) = "startcode = '" & SurName & "'"

[Thom]

Wow! Thank you both! Scott, I'll remember your advice, BruceG your code worked like a charm! Thanks guys!

What's Crystal Reprts used for?

[BruceG]

Thom: Glad to be of service.
Sc0rp: CR is used mostly to give VB reporting capabilities for VB database apps (similar to the report-writing feature of Access).