I have a text box on a report called Procedure that has a record source of Procedure.

I am trying to make the record source be:

=iif([Category]="Glasses",[Procedure],"0")

when the expression runs, it gives me the source of Procedure no matter if it's true or false. [Category] is a listbox with different values in there.

Another question is, instead of displaying the "0", what I really want is to skip the line and go to next. Any idea how to do that?

Thank you.

Regards

Loke

Similar post at
http://p2p.wrox.com/topic.asp?TOPIC_ID=15874

Love 4 all

Make the textbox UNbound, then put that criteria in your recordsource property. Because you put the textbox's recordsource equal to [Procedure] (i.e. bound), it's overriding your assignment.

If you rather not show anything there you can put

=Iif([Category] = "Glasses", [Procedure], Null)

or

=Iif([Category] = "Glasses", [Procedure], "")

Because you're working in a report, assigning NULL or "" won't make a difference on a print-out. If you were working in a form, THEN there would be a difference and you'd have to be careful which you want.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,

Null and "" didn't help. The report that I have right now looks like this:

=======================
Column A Column B
Record 1
Record 2
             Record 3
             Record 4
=======================

What I want is:

=======================
Column A Column B
Record 1 Record 3
Record 2 Record 4
=======================

So to elimate the space there, and to be able to print out on the same sheet of paper.

I did use the unbound text box with the iif statement. Any idea how to do that?

Thank you.

Loke