Don't show when Price = empty

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

Guest

Hi
I'm trying to fine tune some of the display of my report.

I'm displaying a customer price sheet
Some of my customers have addresses with line 1 and line 2. I have both on my form. But if they only have line 1 , I'd like to not have the space
Is the same rule - if I have a label for fax number but no fax number, I don't want the label.
I know I can say, if not null or "" in a query
Does this have to be in a query to validate or is there another way

If I'm displaying price / measur
$1.00 / sq. ft. where the / is a label and the measure is a field pulled in -- if there's no price, can I have them not display.

The logic is escaping me
Thanks
 
Hi:

In the Control Source for your Control on report create a foruma like
this --

Iif(IsNull(FaxNumber] Or [FaxNumber]="","","Fax: " & [FaxNumber])

For the price field

Iif(IsNull([Price]) or [Price]=0,"","Price: " & [Price])

Regards,

Naresh Nichani
Microsoft Access MVP


Martha said:
Hi.
I'm trying to fine tune some of the display of my report.

I'm displaying a customer price sheet.
Some of my customers have addresses with line 1 and line 2. I have both on
Click to expand...
my form. But if they only have line 1 , I'd like to not have the space.
Is the same rule - if I have a label for fax number but no fax number, I don't want the label.
I know I can say, if not null or "" in a query.
Does this have to be in a query to validate or is there another way?

If I'm displaying price / measure
$1.00 / sq. ft. where the / is a label and the measure is a field pulled
Click to expand...
in -- if there's no price, can I have them not display.
 
Back
Top