conditional Change of field properties in a report

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

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?
 
Check the replies to your same question from Jan. 3.
You can only change control properties like this in design view or code.
 
Thanks. I need to do this for each record. Any Suggestions?

Frank

Duane Hookom said:
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
--

Frank said:
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?
Click to expand...
Click to expand...
 
Code in the On Format event of the detail section will run the code for each
record.

--
Duane Hookom
MS Access MVP
--

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

Frank

Duane Hookom said:
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
--

Frank said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top