I have a report that uses a crosstab query and I have been forced to bring all the data through in one string for it to sort and display as wanted.
Is there any way I can format the font size at either the query stage or in the report so that the 1st line is smaller that the second & third.
I have used this to create the string and add returns in:
Vs: Sports.Sport & Chr(13) & Chr(10) & " " & Last(Teams.Name & Chr(13) & Chr(10) & " Vs. " & teams_1.name)
This returns something like in a single text box:
Soccer
Team A
VS. Team B
I would like to reduce the size of the Sport name.
Suggestions?
Is there any way I can format the font size at either the query stage or in the report so that the 1st line is smaller that the second & third.
I have used this to create the string and add returns in:
Vs: Sports.Sport & Chr(13) & Chr(10) & " " & Last(Teams.Name & Chr(13) & Chr(10) & " Vs. " & teams_1.name)
This returns something like in a single text box:
Soccer
Team A
VS. Team B
I would like to reduce the size of the Sport name.
Suggestions?