Conditional Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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".
 
Yes has no meaning. Use True or -1. True is better because it is eacy to
read.
 
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
 
You must log in or register to reply here.

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

TextBox Object Control Source Expresion, trouble with 3
Text box visible on a continuous form 3
Invoice Report 1
formating an unbound text box 1
Sum() issue 2
Editing One Field Changes Another Field 1
Null Value in Subform Total 4
iff, then, else textbox help!!! 5

Back
Top