Text label conditionally visible on report?

[paulml]

Hello Guys
I'm running Access 2003 and my question relates to delivery notes that are produced for drivers as reports. These delivery notes have a blank payment box for the driver to complete if the customer pays upon delivery.
As more and more customers are prepaying by credit cards, I'd like this payment box to be automatically filled with a "PAID" text which will let the driver know the order has already been paid for.
The delivery note is produced from an "Orders" table which has a "Paid" field whose value is automatically set to "Yes" when the order has been paid for.
I was hoping to be able to place a "PAID" label on the report which is only visible when the Paid field of the underlying query is Yes.
As things are at the moment I cannot see any way to put any conditional statement onto this Text/Label. The only options for the "Is Visible" property of the text are Yes or No.
I'm sure there must be some way to do this but not being the most experienced user, I'm not sure where to go from here.
Any pointers would be greatly appreciated.
Thank you for your time in advance.

 

[Mihail]

I'm sure there must be some way to do this...

It is... if you think a bit out of box.
What you need ? Something to tell show the word "Paid" or to show... nothing.
So, use a text box and set the Control Source to
=IIF([Paid],"Paid","")

 

[Mihail]

The delivery note is produced from an "Orders" table which has a "Paid" field whose value is automatically set to "Yes" when

This is a bad practice. The "Paid" field is not necessary.
DB rule: Do not store what you can calculate.
So, you can show the word "Paid" using the value of field... "Money" (?). I don't know the word in English. Any way you should have a field where you store the amount of money for each Order.
IIF([Money] Is Null,"","Paid") (Not very sure about the syntax)

 

[paulml]

Wow!
Speedy response.
That's great, thank you!
I'll try to work around that and will get back if I can't solve it.
Thanks for your help and Happy New Year!

 

[Mihail]

Thanks for your help and Happy New Year!

You too !!!!!!!!!