Complications on my Report!

  • Thread starter Thread starter sabz
  • Start date Start date
S

sabz

Hi, thanks for the previous kind-hearted person who helped me. I have
yet another problem to overcome...

I'm trying to print a report with a lot of data...

Here is where my problem lies... There are a few fields (about 4) that
need to have specific values on them based on something...

For example - i have a phone number field.

if there is a phone number provided in my table - i want the report to
say
Phone Number: "Private" (i.e. i want it to be hidden)
or if there isn't one provided i want the report to say
Phone Number: "Not provided" (i.e. i want it to say that it hasn't been
provided)

I've tried building an expression, but in the report tabs, the code
just confuses me, and besides there isn't a simple way to build an
expression for a particular field...

Please help - anything will help!

Thanks, Sabrina
 
Hi, thanks for the previous kind-hearted person who helped me. I have
yet another problem to overcome...

I'm trying to print a report with a lot of data...

Here is where my problem lies... There are a few fields (about 4) that
need to have specific values on them based on something...

For example - i have a phone number field.

if there is a phone number provided in my table - i want the report to
say
Phone Number: "Private" (i.e. i want it to be hidden)
or if there isn't one provided i want the report to say
Phone Number: "Not provided" (i.e. i want it to say that it hasn't been
provided)

I've tried building an expression, but in the report tabs, the code
just confuses me, and besides there isn't a simple way to build an
expression for a particular field...

Please help - anything will help!

Thanks, Sabrina
Click to expand...

Use an unbound text control.
Set it's control source to:
=IIf(IsNull([PhoneField]),"Phone Number: Not provided","Phone Number:
Private")

Make sure the name of this control is NOT 'PhoneField'.
 
Thanks for your help Fred - worked like a charm =)
Hi, thanks for the previous kind-hearted person who helped me. I have
yet another problem to overcome...

I'm trying to print a report with a lot of data...

Here is where my problem lies... There are a few fields (about 4) that
need to have specific values on them based on something...

For example - i have a phone number field.

if there is a phone number provided in my table - i want the report to
say
Phone Number: "Private" (i.e. i want it to be hidden)
or if there isn't one provided i want the report to say
Phone Number: "Not provided" (i.e. i want it to say that it hasn't been
provided)

I've tried building an expression, but in the report tabs, the code
just confuses me, and besides there isn't a simple way to build an
expression for a particular field...

Please help - anything will help!

Thanks, Sabrina
Click to expand...

Use an unbound text control.
Set it's control source to:
=IIf(IsNull([PhoneField]),"Phone Number: Not provided","Phone Number:
Private")

Make sure the name of this control is NOT 'PhoneField'.
Click to expand...
 
Back
Top