label

[mccoy]

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

 

[Allen Browne]

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

 

[mccoy]

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:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

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"
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

 

[Allen Browne]

Do you have a check box named checkbox1?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

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"
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

 

[mccoy]

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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

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"
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

 

[Allen Browne]

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.