label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mccoy - 15 Mar 2007 10:41 GMT

i would like to create a label that would appear the word "INVOICED IN FULL"
when the my checkbox1 is set to "yes" and it will change to "PAID" when the
field1 is set to 0 value
by default it is not visible when new record is added unless the checkbox is
checked

what is the right code for this
thnx in advance

Reply to this Message

Allen Browne - 15 Mar 2007 11:12 GMT

You could use a text box, and set its Control Source to something like this:

=IIf([checkbox1], IIf([Field1] = 0, "PAID", "INVOICED IN FULL", Null))

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>i would like to create a label that would appear the word "INVOICED IN
>FULL"
[quoted text clipped - 7 lines]
> what is the right code for this
> thnx in advance

Reply to this Message

mccoy - 16 Mar 2007 01:23 GMT

sir i copy the expression u gave me but i received an error arguments

tnx much

> You could use a text box, and set its Control Source to something like this:
>
[quoted text clipped - 11 lines]
> > what is the right code for this
> > thnx in advance

Reply to this Message

Allen Browne - 16 Mar 2007 02:13 GMT

Do you have a check box named checkbox1?

Do you have a field name Field1? Is it bound to a Number type field?

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> sir i copy the expression u gave me but i received an error arguments
>
[quoted text clipped - 18 lines]
>> > what is the right code for this
>> > thnx in advance

Reply to this Message

mccoy - 16 Mar 2007 04:51 GMT

i put the corresponding field name but it says you have entered a wrong
arguments on the control source

> Do you have a check box named checkbox1?
>
[quoted text clipped - 22 lines]
> >> > what is the right code for this
> >> > thnx in advance

Reply to this Message

Allen Browne - 16 Mar 2007 05:46 GMT

Okay, keep working on it.

The principle will work, so it is worth your effort to implement it.
I can't comment on the implementation details, as only you can see your
database.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>i put the corresponding field name but it says you have entered a wrong
> arguments on the control source
[quoted text clipped - 6 lines]
>> >
>> > tnx much

Reply to this Message