Changing report label

[Muttley]

Hi

Is it possible to conditionally format a label or text box on a report so that the title of the report changes depending on another factor (e.g. Whether or not a control on a separate form is null or not).

I've tried to assign a value and I get a run time error 2448 ("You can't assign a value to this object&quot. Is there any way I can get around this?

TIA

Muttley

 

[JoeMiller]

Set up a text box that checks the control's value on your form and assigns the value for the titlewhen the report is run. The control source of the text box will look like this:

=iif([Forms]![FormName]![ControlName]="ValueToFind","Report Title if Value is True","Report Title if Value is False&quot

That will do what you're looking for.

Joe Miller
joe.miller@flotech.net

 

[Muttley]

Hi (again) Joe

I got around this by using the following syntax:

IsNull(Form_frmMenuReports.txtFrom) then
Reports!repWriteOffs!lblTitle.Caption = "Title"

etc.

It just annoys me why there are so many inconsistencies with the way Access does things - I've done exactly the same for Form labels by using me.lblX.Caption = "Title"

Thanks again...Muttley