report field

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

Guest

hi,

i have a report that does not include a particular field. however, i would
like to include that particular field if my criteria form has been used to
open the report and a certain field in the criteria form has been filled in.
however, i do not want to add this field permanently to the design of the
report.

is this possible?

thanks in advance,
geebee
 
geebee said:
hi,

i have a report that does not include a particular field. however, i would
like to include that particular field if my criteria form has been used to
open the report and a certain field in the criteria form has been filled in.
however, i do not want to add this field permanently to the design of the
report.

is this possible?

thanks in advance,
geebee
Click to expand...

Since you need to have the field in the underlying query for the report,
you have a few solutions:
1) Two separate reports, one with the field showing and one without it
<this is a bulky but simple solution>
2) Include the field on the report, but alter what's displayed based on
it's value. For example your control source could read
=IIf([YourField]='', "n/a", [YourField]). So it would either display the
value of the field, or alternate text
3) Use the Detail Format event to check the value of the field (from the
underlying query or the calling criteria form), and then set the Visible
property of the text box (and its label) on the report to true or false
depending on whether you wanted to show it or hide it.
 
Back
Top