checkbox

M

mccoy

can any1 could teach me how to?

i want to set the value of the checkbox on my report if it is set to YES
then the value would appear a text PAID if NO = blank

thanx
 
A

Allen Browne

Assuming you have a yes/no field named Paid, set the Control Source property
of the text box to:
=IIf([Paid], "Paid", Null)
 
M

mccoy

thanks mr. allen

Allen Browne said:
Assuming you have a yes/no field named Paid, set the Control Source property
of the text box to:
=IIf([Paid], "Paid", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

mccoy said:
can any1 could teach me how to?

i want to set the value of the checkbox on my report if it is set to YES
then the value would appear a text PAID if NO = blank

thanx
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Anything will help 0
Creating a checklist with predefined comments 1
Help counting multiple checkboxes in a form to make a total in a report 3
Creating a Chart on form from selected data in query. 0
Checkbox on report - how to make it disappear? 1
How to create bulleted to-do list using two styles? 5
list or combo box 0

Top