Changing Report Title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What does your code look like? Can you post it?
How are you telling the report which option was run?
What version of Access?
 
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
 
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
 
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
 
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 :-)
 
Back
Top