Text Boxes

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I have a text box named [bank] with various data in that
text box. I have that text box in a grouping with a header
and the report footer. I have data in that text box
named "Chief Financial Officer" within all the data. I
would like the header to say "Chief Financial Officer" and
Report Footer to say "Treasury" just on that one bank. How
would I change just that one piece of data without
changing all the other data?


Thanks in advance
Penny
 
You could do this with two IIF statements:
In the header you could make it:
=IIF([Bank] = "when you want to specify", "Chief Financial
Officer",[The name of the original variable])
The IIF statement is very nice to make conditional canges.
Hope this helps.
Happy New Year.
Fons
-----Original Message-----
Click to expand...
I have a text box named [bank] with various data in that
text box. I have that text box in a grouping with a header
and the report footer. I have data in that text box
named "Chief Financial Officer" within all the data. I
would like the header to say "Chief Financial Officer" and
Report Footer to say "Treasury" just on that one bank. How
would I change just that one piece of data without
changing all the other data?
 
Back
Top