IIF question

A

Amir

Hi!

I'm trying to make a text box in a report be
visible only if other field's value is true.
This text box is a title for a group in the report.
I've tried setting the text box's source to:

=IIf([HasMaterialType]=True,("SubList for Material_
Type:" & [MaterialType]),"")

But I got an #Error in the report's page.

Is there any way I can make the whole group title
not to show in this case?

I don't want the Material Types title to show for
products that are not assigned with
material type. HasMaterialType is a field
in the Table tblProductsType,
and is included in the report's source using a query.

Regrads.
 
A

Amir

Thank you,

I've solved it using the format event.


Duane Hookom said:
Make sure the name of the control is not also the name of a field.

--
Duane Hookom
MS Access MVP


Amir said:
Hi!

I'm trying to make a text box in a report be
visible only if other field's value is true.
This text box is a title for a group in the report.
I've tried setting the text box's source to:

=IIf([HasMaterialType]=True,("SubList for Material_
Type:" & [MaterialType]),"")

But I got an #Error in the report's page.

Is there any way I can make the whole group title
not to show in this case?

I don't want the Material Types title to show for
products that are not assigned with
material type. HasMaterialType is a field
in the Table tblProductsType,
and is included in the report's source using a query.

Regrads.
Click to expand...
Click to expand...
 
Top