checkbox

[Guest]

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

 

[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)

 

[Guest]

thanks mr. allen

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.

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