formula fields at runtime
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?