text box to reference a variable name

[Geordie2008]

Hi all,

On my report I have a field called "Region"

I am doing a sub total of this using the GroupFooter.

I want the label of the text box to be the Region in question and then the text "subtotal".

E.g.

Asia Subtotal
Europe Subtotal

I tried the following:

=Region & "Subtotal:"

But it treats it all as text and the formula is what I see on the report

Plz Help!
Mandy

 

[gemma-the-husky]

mylabel.caption = region & " subtotal:" should do it

but needs to be done in code, to get it into a label caption
try the groupfooter, format or print event

 

[Geordie2008]

works a treat,
Many thanks,
Mandy