Changing Report Title

H

hughess7

Hi all

I have a report that is used by real data and forecast data, the only detail
that will be different is the title to distinguish which report option was
run. I have tried amending the label object on format of the page header via
code but I receive an error that object does not support this method.

Can anyone help please?
Thanks
Sue
 
K

Klatuu

What does your code look like? Can you post it?
How are you telling the report which option was run?
What version of Access?
 
H

hughess7

Hi

Access 2003.

I have an option group on a form for the user to select 'Actual' or
'forecast' (option 1 or 2). I will post the code tomorrow thanks when I am
back in work.

Sue
 
H

hughess7

Hi again

Had a sudden brain wave and decided to try something ....the control was a
label, changed it to an unbound text field and it now works :).

Thanks anyway
Sue
 
K

Klatuu

Glad you got it working. FYI, my guess is that since you changed from a
label to a text box, it was a matter of using the correct property. If you
want to include the text value of a lable, you need to reference the Caption
property:

=Forms!frmAnyForm!lblType.Caption
 
H

hughess7

Thanks, good to know these things! I've used Access for years but don't class
myself as a programmer. But thanks to you guys I am learning all the time :)
 
Top