label visibility based on report field?

[Guest]

hello all..

I have an invoice report that I use for both sold invoices and conignment
invoices, and a field on my report called invoicetype (with is either "Sold"
or "Consignment"..
And two labels: "Invoice" - named invoicelable and "Consignment Invoice" -
named consignlabel

I would like the Invoice label to be visible if the invoice type is "Sold"
and the Conignment Invoice Lable to be invisible and visa versa?

I tried the following:

If invoicetype = "Sold" Then
invoicelabel.visible = True
consignlabel.visible = False
Else
invoicelabel.visible = False
consignlabel.visible = True

End if
End IF

I tried to enter this code in the code of the form, but was unsuccessfull
in getting it to work ?

Any ideas?

Thanks,

Brook

 

[Rick B]

You say that you tried the following code, but you don't tell us where you
put that code. What event?


If it were me, I'd just add an unbound field to my report and include an if
statement to say IF invoice type = Sold, then print Invoice otherwise print
Consignment invoice. Something lik...


= IF([invoicetype] = "Sold","Invoice","Consignment Invoice")

 

[Guest]

Thanks for the reply Rick,

In my original post I had that I tried the code in the code for the report
itself, but beyond that.

I tried your suggested code, which I should have thought of instead of
trying to make things so much more difficult, but then I got an "Enter
parameter value", then had the word 'if'.

I changed my code to the following and it worked fine:

=IIf(([invoicetype])="Sold","Invoice", "Consignment Invoice")

why would that make a difference?

Thanks for your help.

Brook

You say that you tried the following code, but you don't tell us where you
put that code. What event?


If it were me, I'd just add an unbound field to my report and include an if
statement to say IF invoice type = Sold, then print Invoice otherwise print
Consignment invoice. Something lik...


= IF([invoicetype] = "Sold","Invoice","Consignment Invoice")




--
Rick B

hello all..

I have an invoice report that I use for both sold invoices and conignment
invoices, and a field on my report called invoicetype (with is either "Sold"
or "Consignment"..
And two labels: "Invoice" - named invoicelable and "Consignment Invoice" -
named consignlabel

I would like the Invoice label to be visible if the invoice type is "Sold"
and the Conignment Invoice Lable to be invisible and visa versa?

I tried the following:

If invoicetype = "Sold" Then
invoicelabel.visible = True
consignlabel.visible = False
Else
invoicelabel.visible = False
consignlabel.visible = True

End if
End IF

I tried to enter this code in the code of the form, but was unsuccessfull
in getting it to work ?

Any ideas?

Thanks,

Brook

 

[Rick B]

That is correct. IIF is what you use in a control. IF is what you use in
vba.



--
Rick B

Thanks for the reply Rick,

In my original post I had that I tried the code in the code for the report
itself, but beyond that.

I tried your suggested code, which I should have thought of instead of
trying to make things so much more difficult, but then I got an "Enter
parameter value", then had the word 'if'.

I changed my code to the following and it worked fine:

=IIf(([invoicetype])="Sold","Invoice", "Consignment Invoice")

why would that make a difference?

Thanks for your help.

Brook

You say that you tried the following code, but you don't tell us where you
put that code. What event?


If it were me, I'd just add an unbound field to my report and include an if
statement to say IF invoice type = Sold, then print Invoice otherwise print
Consignment invoice. Something lik...


= IF([invoicetype] = "Sold","Invoice","Consignment Invoice")




--
Rick B

hello all..

I have an invoice report that I use for both sold invoices and conignment
invoices, and a field on my report called invoicetype (with is either "Sold"
or "Consignment"..
And two labels: "Invoice" - named invoicelable and "Consignment Invoice" -
named consignlabel

I would like the Invoice label to be visible if the invoice type is "Sold"
and the Conignment Invoice Lable to be invisible and visa versa?

I tried the following:

If invoicetype = "Sold" Then
invoicelabel.visible = True
consignlabel.visible = False
Else
invoicelabel.visible = False
consignlabel.visible = True

End if
End IF

I tried to enter this code in the code of the form, but was unsuccessfull
in getting it to work ?

Any ideas?

Thanks,

Brook

 

[Mike Painter]

Thanks for the reply Rick,

In my original post I had that I tried the code in the code for the
report itself, but beyond that.

I tried your suggested code, which I should have thought of instead of
trying to make things so much more difficult, but then I got an "Enter
parameter value", then had the word 'if'.

I changed my code to the following and it worked fine:

=IIf(([invoicetype])="Sold","Invoice", "Consignment Invoice")

why would that make a difference?

You did what Rick wrote rather than what he meant