Automatic Text in Report

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I have a report where I've got a text box that could be
one of two values that it pulls from a query. I'd like to
make another box that changes based on what appears in the
text box.

If the text box reads "Project Management Board Meeting"
then the second box would read "Meeting was held to
discuss the list of current project proposals with the
Project Management Board and receive direction concerning
which proposals should be elevated to project status and
funded."
If the text box reads "Project Progress Meeting" then the
second box would read "Meeting was held to discuss the
status of current projects."

Is there a way to do this in the report? Should I make
another field in my table? Can a query do this?

I would also like to ask if there is a way to hide the
label of a text box if there is no text in it. I've got
the text box set to Can Shrink, but the label still
appears when the box is empty.

Thank you,

Jennifer
 
I have a report where I've got a text box that could be
one of two values that it pulls from a query. I'd like to
make another box that changes based on what appears in the
text box.

If the text box reads "Project Management Board Meeting"
then the second box would read "Meeting was held to
discuss the list of current project proposals with the
Project Management Board and receive direction concerning
which proposals should be elevated to project status and
funded."
If the text box reads "Project Progress Meeting" then the
second box would read "Meeting was held to discuss the
status of current projects."

Is there a way to do this in the report? Should I make
another field in my table? Can a query do this?

I would also like to ask if there is a way to hide the
label of a text box if there is no text in it. I've got
the text box set to Can Shrink, but the label still
appears when the box is empty.

Thank you,

Jennifer
Click to expand...

One way:
Add an unbound control to the report.
Set it's Control Source to:

= IIf([ControlA] = "Project Management Board Meeting" ,"Meeting was
held to discuss the list of current project proposals with the Project
Management Board and receive direction concerning which proposals
should be elevated to project status and funded.","Meeting was held
to discuss the status of current projects.")

Another way:
Have 2 labels, one with each message, placed one directly on top of
the other.
Then code the Detail Section format event:

LabelA.Visible = [ControlA] = "Project Management Board Meeting"
LabelB.Visible = Not [ControlA] = "Project Management Board Meeting"
 
Hi Jennifer.
Yes you can.
-----Original Message-----
I have a report where I've got a text box that could be
Click to expand...
one of two values that it pulls from a query. I'd like to
make another box that changes based on what appears in the
text box.
If the text box reads "Project Management Board Meeting"
Click to expand...
then the second box would read "Meeting was held to
discuss the list of current project proposals with the
Project Management Board and receive direction concerning
which proposals should be elevated to project status and
funded."
If the text box reads "Project Progress Meeting" then the
second box would read "Meeting was held to discuss the
status of current projects."
Is there a way to do this in the report?
Click to expand...
In the report in design view place an unbound textbox, in
the source for this textbox type:
=IIF([YourData1]= "Project Management Board
Meeting","Meeting was held to discuss the list of current
project proposals with the Project Management Board and
receive direction concerning which proposals should be
elevated to project status and funded.",IIF ([YourData1]
= "Project Management Board Meeting","Meeting was held to
discuss the list of current project proposals with the
Project Management Board and receive direction concerning
which proposals should be elevated to project status and
funded.","No Comment"))
All of the above from the = through the )) is on one line.
Should I make another field in my table? Can a query do
Click to expand...
this? you could also place the same IIF in a query and
just skip the =.
I would also like to ask if there is a way to hide the
Click to expand...
label of a text box if there is no text in it. I've got
the text box set to Can Shrink, but the label still
appears when the box is empty.
Change the label to a textbox, and use a similar IIF
statement, like:
=IIF([YourData] is null,"","Your Label")
now you can set the can shrink for this textbox to can
shrink and set the report band property can shrink to yes
to hide the blank line.

Hope this helps.
Fons
 
Back
Top