Hi

I want to pass a string to a formula field on the report. Everytime I try to run the report, it says - 'The remaining text doesnot appear to be part of the formula. If I pass the strings - "Yes" or "No", it displays True or False without any error.

Following is my code

Dim myFormulas As FormulaFieldDefinitions

        Dim FormulaField5 As FormulaFieldDefinition
        myFormulas = Me.rpt.DataDefinition.FormulaFields

        FormulaField5 = myFormulas.Item(0)

        Dim strPlayer As String
        strPlayer = "Player11"

        FormulaField5.Text = strPlayer

____________________________________________

How should I modify the code to make the report accept the string?

Thanks,
Gauri

Solved the problem.
The string should have a single quote too. i.e. strPlayer = "'Player11'"

Should be written like this.
Me.Rpt.DataDefinition.FormulaFields.Item(0).Text = """" & strPlayer & """"