Display text lable and field content conditionaly part 2

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Duane Hookom was helping me and I thought I had gotten it right, but for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the check box
named "DestGER" I get an error #ERROR all the time regardless of the value
in the controlling source. Can this be used with a check box? I don't really
need to have the check box show, as this is a pallet label and I just need
to have GER to show the country of destination when there is a value in the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error #Error
when there is a value in the box and the label should be shown and when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
 
Michael

I suspect that your approach is not working because Duane mentioned that a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
Click to expand...
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Michael said:
Duane Hookom was helping me and I thought I had gotten it right, but for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the check box
named "DestGER" I get an error #ERROR all the time regardless of the value
in the controlling source. Can this be used with a check box? I don't really
need to have the check box show, as this is a pallet label and I just need
to have GER to show the country of destination when there is a value in the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error #Error
when there is a value in the box and the label should be shown and when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
 
You can try:
=IIf(IsNull([DestGER]),"GER",Null)
--
Duane Hookom
MS Access MVP
--

Jeff Boyce said:
Michael

I suspect that your approach is not working because Duane mentioned that a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
Click to expand...
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Michael said:
Duane Hookom was helping me and I thought I had gotten it right, but for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the check box
named "DestGER" I get an error #ERROR all the time regardless of the
value
in the controlling source. Can this be used with a check box? I don't really
need to have the check box show, as this is a pallet label and I just
need
to have GER to show the country of destination when there is a value in the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error
#Error
when there is a value in the box and the label should be shown and when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
Click to expand...
 
Thanks Duane,
This is almost there.. I am not using the Destger check boxes, but still
trying to get it to work on the other form. What I need is an expression
that says
"is not null" because when I have a value in the text box, I want the label
to show. I have searched all the help files and still cannot come up with an
answer.
thank you again
Michael






Duane Hookom said:
You can try:
=IIf(IsNull([DestGER]),"GER",Null)
--
Duane Hookom
MS Access MVP
--

Jeff Boyce said:
Michael

I suspect that your approach is not working because Duane mentioned that
a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
Click to expand...
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Michael said:
Duane Hookom was helping me and I thought I had gotten it right, but for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the check box
named "DestGER" I get an error #ERROR all the time regardless of the
value
in the controlling source. Can this be used with a check box? I don't really
need to have the check box show, as this is a pallet label and I just
need
to have GER to show the country of destination when there is a value in the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error
#Error
when there is a value in the box and the label should be shown and when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
Click to expand...
Click to expand...
 
What I meant to say is that I am not using the check boxes that were using
destGer. I have change them to a listbox, but I am still trying to get this
expression to work on another report.

=IIf(IsNull([RucolaSelvatica]);"RucolaSelvatica") is what I have. I want the
textbox txtRucolaSelvatica to only show the label "Rucola Selvatica" when
there is a value in textbox [RucolaSelvatica]. With this expression the
label only shows when the textbox is null. Is there a way to say IsNotNull
as.....=IIf(IsNotNull([RucolaSelvatica]);"RucolaSelvatica")

thank you
Michael






Michael said:
Thanks Duane,
This is almost there.. I am not using the Destger check boxes, but still
trying to get it to work on the other form. What I need is an expression
that says
"is not null" because when I have a value in the text box, I want the
label to show. I have searched all the help files and still cannot come up
with an answer.
thank you again
Michael






Duane Hookom said:
You can try:
=IIf(IsNull([DestGER]),"GER",Null)
--
Duane Hookom
MS Access MVP
--

Jeff Boyce said:
Michael

I suspect that your approach is not working because Duane mentioned that
a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a
checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Duane Hookom was helping me and I thought I had gotten it right, but
for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the
check
box
named "DestGER" I get an error #ERROR all the time regardless of the
value
in the controlling source. Can this be used with a check box? I don't
really
need to have the check box show, as this is a pallet label and I just
need
to have GER to show the country of destination when there is a value in
the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error
#Error
when there is a value in the box and the label should be shown and when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
Click to expand...
Click to expand...
 
=IIf(IsNull([RucolaSelvatica]);Null;"RucolaSelvatica")

--
Duane Hookom
MS Access MVP
--

Michael said:
What I meant to say is that I am not using the check boxes that were using
destGer. I have change them to a listbox, but I am still trying to get
this expression to work on another report.

=IIf(IsNull([RucolaSelvatica]);"RucolaSelvatica") is what I have. I want
the textbox txtRucolaSelvatica to only show the label "Rucola Selvatica"
when there is a value in textbox [RucolaSelvatica]. With this expression
the label only shows when the textbox is null. Is there a way to say
IsNotNull as.....=IIf(IsNotNull([RucolaSelvatica]);"RucolaSelvatica")

thank you
Michael






Michael said:
Thanks Duane,
This is almost there.. I am not using the Destger check boxes, but still
trying to get it to work on the other form. What I need is an expression
that says
"is not null" because when I have a value in the text box, I want the
label to show. I have searched all the help files and still cannot come
up with an answer.
thank you again
Michael






Duane Hookom said:
You can try:
=IIf(IsNull([DestGER]),"GER",Null)
--
Duane Hookom
MS Access MVP
--

message Michael

I suspect that your approach is not working because Duane mentioned
that a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a
checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a
checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Duane Hookom was helping me and I thought I had gotten it right, but
for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the
check
box
named "DestGER" I get an error #ERROR all the time regardless of the
value
in the controlling source. Can this be used with a check box? I don't
really
need to have the check box show, as this is a pallet label and I just
need
to have GER to show the country of destination when there is a value
in
the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error
#Error
when there is a value in the box and the label should be shown and
when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the
Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
Click to expand...
Click to expand...
 
Thank you very much.. that works like a charm.. I have been stuck on this
for awhile now I can move forward.
Michael

Duane Hookom said:
=IIf(IsNull([RucolaSelvatica]);Null;"RucolaSelvatica")

--
Duane Hookom
MS Access MVP
--

Michael said:
What I meant to say is that I am not using the check boxes that were
using destGer. I have change them to a listbox, but I am still trying to
get this expression to work on another report.

=IIf(IsNull([RucolaSelvatica]);"RucolaSelvatica") is what I have. I want
the textbox txtRucolaSelvatica to only show the label "Rucola Selvatica"
when there is a value in textbox [RucolaSelvatica]. With this expression
the label only shows when the textbox is null. Is there a way to say
IsNotNull as.....=IIf(IsNotNull([RucolaSelvatica]);"RucolaSelvatica")

thank you
Michael






Michael said:
Thanks Duane,
This is almost there.. I am not using the Destger check boxes, but still
trying to get it to work on the other form. What I need is an expression
that says
"is not null" because when I have a value in the text box, I want the
label to show. I have searched all the help files and still cannot come
up with an answer.
thank you again
Michael






"Duane Hookom" <[email protected]> ha scritto nel messaggio
You can try:
=IIf(IsNull([DestGER]),"GER",Null)
--
Duane Hookom
MS Access MVP
--

message Michael

I suspect that your approach is not working because Duane mentioned
that a
Null in the field [Tomatoes] would cause the expression
="Tomatoes " + [Tomatoes]
to evaluate to Null in a textbox control.

If I understand your post, you are trying to do the same with a
checkbox
(Y/N). Are you sure that can evaluate to Null? Are you using a
checkbox
control bound to an underlying field?

--
Regards

Jeff Boyce
<Office/Access MVP>

Duane Hookom was helping me and I thought I had gotten it right, but
for
some reason, I now get a error when I use the following

="GER "+[DestGER]. This is a text box that relates the to the
check
box
named "DestGER" I get an error #ERROR all the time regardless of the
value
in the controlling source. Can this be used with a check box? I don't
really
need to have the check box show, as this is a pallet label and I just
need
to have GER to show the country of destination when there is a value
in
the
check box


on another page

I have ="RucolaSelvatica "+[RucolaSelvatica] I get the error
#Error
when there is a value in the box and the label should be shown and
when
there is no value, the label is not show which is correct.

below is the help that Duane gave me.

thank you
Michael




Assuming you have a field named [Tomatoes]. You can change the
Tomatoes
label to a text box and set its control source to
="Tomatoes " + [Tomatoes]
If the Tomatoes field is Null then the "label" will not display.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top