Variable in reports

[Alex H]

Hi I am creating a report which I want to insert some variables.
I assume I create an unbound text box and i then put the datasource as
=variablename, but that didn't work. Can someone tell me what the correct
syntax is please

thanks

A

 

[Allen Browne]

Variables cannot be retrieved directly by text boxes.

You might use the Format event of the report section that contains the text
box, e.g.:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Me![SomeTextbox] = SomeVariable
End Sub

Alternatively, you could create a function to return the value of the
variable:
Public Function GetMyVariable() As Variant
GetMyVariable = SomeVariable
End Sub
Then you could set the Control Source of the text box to:
=GetMyVariable()

 

[Alex H]

Thanks

Alex

Variables cannot be retrieved directly by text boxes.

You might use the Format event of the report section that contains the text
box, e.g.:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
Me![SomeTextbox] = SomeVariable
End Sub

Alternatively, you could create a function to return the value of the
variable:
Public Function GetMyVariable() As Variant
GetMyVariable = SomeVariable
End Sub
Then you could set the Control Source of the text box to:
=GetMyVariable()

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi I am creating a report which I want to insert some variables.
I assume I create an unbound text box and i then put the datasource as
=variablename, but that didn't work. Can someone tell me what the correct
syntax is please