Show picture on field based on whether or not Yes/No box is checked

[robertmarkdudley95]

I have an invoice form, and at present it appears fine. However, I want this picture:





to appear on the report if the job has been paid for. How do I do this?

[June7]

How do you know the job is paid? What field has value that could be used in conditional statement?

Use code in the Detail section Format event.

Me.imagecontrolname.Visible = expression that evaluates True or False

[robertmarkdudley95]

How do you know the job is paid? What field has value that could be used in conditional statement?

Use code in the Detail section Format event.

Me.imagecontrolname.Visible = expression that evaluates True or False

Well, the Paid? expression comes from a Yes/No box, so would it be something along the lines of:

Me.imagecontrolname.Visible = Me.[Paid?].Checked = True

[June7]

Looks right, try it.

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names. Better would be IsPaid instead of Paid?.

[robertmarkdudley95]

Looks right, try it.

BTW, advise not to use spaces, special characters, punctuation (underscore is exception) in names. Better would be IsPaid instead of Paid?.

Great! I put it in the OnLoad event and it works great!

Thanks for your help, June7