Conditional Textbox

S

Steven

Hi, I'm new to Forms Coding, I would like a text box to display the word
"member" if a value in the forms underlying query is true (bit - checkbox)

I have the following as the text box's control source:
IIf(Nz(ActiveMemberCompany)) = yes, "Member")

not working, please help, thanks
 
F

fredg

Hi, I'm new to Forms Coding, I would like a text box to display the word
"member" if a value in the forms underlying query is true (bit - checkbox)

I have the following as the text box's control source:
IIf(Nz(ActiveMemberCompany)) = yes, "Member")

not working, please help, thanks
Click to expand...

Using an unbound text control:
=IIf([CheckBoxFieldName]=-1,"Member","")

Make sure the name of this control is not "CheckBoxFieldName".
 
S

Steven

thanks much, tried "true" before and couldnt get it, would you believe i
forgot the equal sign at the beginning, looonggg day! Thanks for your help
 
Top