label

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

Guest

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
 
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))
 
sir i copy the expression u gave me but i received an error arguments

tnx much

Allen Browne said:
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.

mccoy said:
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
Click to expand...
Click to expand...
 
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.

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

tnx much

Allen Browne said:
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.

mccoy said:
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
Click to expand...
Click to expand...
Click to expand...
 
i put the corresponding field name but it says you have entered a wrong
arguments on the control source



Allen Browne said:
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.

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

tnx much

Allen Browne said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.
 
Back
Top