conditional Change of field properties in a report

[Guest]

I want to change the size of certain fields on a report based on the content
of another field in the report. I tried using an IIF statement, but
apparently my syntax is wrong for entering the subject properties.

The field to change is "text29"

I tried the following in the Data Source property in "text28"

The source of the data is a field named "Jan"

=iif([Jan]=1,[Text29].Height=.1597,[Text29].Height=.0201)

All I get is 0 or -1 in Text28, and no change to Text29.

What is the proper syntax for specifying field properties in this case?

 

[Duane Hookom]

Check the replies to your same question from Jan. 3.
You can only change control properties like this in design view or code.

 

[Guest]

Thanks. I need to do this for each record. Any Suggestions?

Frank

Check the replies to your same question from Jan. 3.
You can only change control properties like this in design view or code.

--
Duane Hookom
MS Access MVP
--

I want to change the size of certain fields on a report based on the
content
of another field in the report. I tried using an IIF statement, but
apparently my syntax is wrong for entering the subject properties.

The field to change is "text29"

I tried the following in the Data Source property in "text28"

The source of the data is a field named "Jan"

=iif([Jan]=1,[Text29].Height=.1597,[Text29].Height=.0201)

All I get is 0 or -1 in Text28, and no change to Text29.

What is the proper syntax for specifying field properties in this case?

 

[Duane Hookom]

Code in the On Format event of the detail section will run the code for each
record.

--
Duane Hookom
MS Access MVP
--

Thanks. I need to do this for each record. Any Suggestions?

Frank

Check the replies to your same question from Jan. 3.
You can only change control properties like this in design view or code.

--
Duane Hookom
MS Access MVP
--

I want to change the size of certain fields on a report based on the
content
of another field in the report. I tried using an IIF statement, but
apparently my syntax is wrong for entering the subject properties.

The field to change is "text29"

I tried the following in the Data Source property in "text28"

The source of the data is a field named "Jan"

=iif([Jan]=1,[Text29].Height=.1597,[Text29].Height=.0201)

All I get is 0 or -1 in Text28, and no change to Text29.

What is the proper syntax for specifying field properties in this case?