Conditional Textbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 16 Aug 2006 19:40 GMT

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

Reply to this Message

fredg - 16 Aug 2006 20:16 GMT

> 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)
[quoted text clipped - 3 lines]
>
> not working, please help, thanks

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

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Klatuu - 16 Aug 2006 20:36 GMT

Yes has no meaning. Use True or -1. True is better because it is eacy to
read.

Reply to this Message

Steven - 16 Aug 2006 21:15 GMT

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

> Yes has no meaning. Use True or -1. True is better because it is eacy to
> read.
[quoted text clipped - 6 lines]
> >
> > not working, please help, thanks

Reply to this Message