Using Special Values

This example shows how to use Special Values in Report Component. In this instance, we will change the value of a control called MySpecialValue which is located in a Report called Users.

Using Properties Window

1. Specify Control Source Type property as Special Value
2. Specify Control Source property as one of the following: RowNumber, TotalPages, CurrentPage, CurrentDate, CurrentTime, CurrentDateTime

Using Coding

1. Add the Before Show event to the control
2. Within the event, add the code below:

Function Users_MySpecialValue_BeforeShow(Sender)

  Users.MySpecialValue.Value = "Row Number: " & Users.RowNumber

End Function

See also