Display text lable and field content conditionaly

[Michael]

I have a dropdown list that as one choice as "mixed" this is a pallet that
has a number of different types of items on it. There are about 50 choices
and currently I have a text field and a label for each field.

They all show all the time even though I use "mixed" very little. Is there a
way to only show these fields when they have content? Is there a way to hide
text labels as well as the fields?
Thank you
Michael

 

[Duane Hookom]

Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set the
control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part and
set it to not grow.

 

[Michael]

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set the
control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part and
set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet that
has a number of different types of items on it. There are about 50 choices
and currently I have a text field and a label for each field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is there a
way to hide text labels as well as the fields?
Thank you
Michael

 

[Duane Hookom]

A control set to allow shrinking will not show when null. The only way that
a text box will show if the value is null is if are displaying the border or
something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set the
control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part
and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet
that has a number of different types of items on it. There are about 50
choices and currently I have a text field and a label for each field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is there a
way to hide text labels as well as the fields?
Thank you
Michael

 

[Michael]

Thank you Duane,
I do not understand how to hide the value and the label this way. I guess I
did not explain well enough.

On the report,I have two sections for each order, one for when and order is
for a full pallet of one type of product and the other part is for a mixed
pallet.
In the first part is a line of info for a single product pallet, when it is
a mixed pallet, I have many fields such as a text box for the amount of
tomatoes and a label that says tomatoes. I would like to only show the
label and the amount for the products that are not null. Currently I have
all the labels showing all the time.

The alternative and preferred way is to show all the labels and values only
when the choice in the Product dropdown list is "Mixed Pallet" Otherwise,
each item has a line with the full information and the items for the mixed
order would be hidden.

A control set to allow shrinking will not show when null. The only way that
a text box will show if the value is null is if are displaying the border
or something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set
the control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part
and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet
that has a number of different types of items on it. There are about 50
choices and currently I have a text field and a label for each field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is there
a way to hide text labels as well as the fields?
Thank you
Michael

 

[Duane Hookom]

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.

If you have a field named Tomatoes then I think your table structure needs
modification.

--
Duane Hookom
MS Access MVP
--

Thank you Duane,
I do not understand how to hide the value and the label this way. I guess
I did not explain well enough.

On the report,I have two sections for each order, one for when and order
is for a full pallet of one type of product and the other part is for a
mixed pallet.
In the first part is a line of info for a single product pallet, when it
is a mixed pallet, I have many fields such as a text box for the amount of
tomatoes and a label that says tomatoes. I would like to only show the
label and the amount for the products that are not null. Currently I have
all the labels showing all the time.

The alternative and preferred way is to show all the labels and values
only when the choice in the Product dropdown list is "Mixed Pallet"
Otherwise, each item has a line with the full information and the items
for the mixed order would be hidden.

A control set to allow shrinking will not show when null. The only way
that a text box will show if the value is null is if are displaying the
border or something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

"Duane Hookom" <[email protected]> ha scritto nel messaggio
Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set
the control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part
and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet
that has a number of different types of items on it. There are about 50
choices and currently I have a text field and a label for each field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is there
a way to hide text labels as well as the fields?
Thank you
Michael

 

[Michael]

Thank you very much.
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.

If you have a field named Tomatoes then I think your table structure needs
modification.

--
Duane Hookom
MS Access MVP
--

Thank you Duane,
I do not understand how to hide the value and the label this way. I guess
I did not explain well enough.

On the report,I have two sections for each order, one for when and order
is for a full pallet of one type of product and the other part is for a
mixed pallet.
In the first part is a line of info for a single product pallet, when it
is a mixed pallet, I have many fields such as a text box for the amount
of tomatoes and a label that says tomatoes. I would like to only show
the label and the amount for the products that are not null. Currently I
have all the labels showing all the time.

The alternative and preferred way is to show all the labels and values
only when the choice in the Product dropdown list is "Mixed Pallet"
Otherwise, each item has a line with the full information and the items
for the mixed order would be hidden.

A control set to allow shrinking will not show when null. The only way
that a text box will show if the value is null is if are displaying the
border or something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

"Duane Hookom" <[email protected]> ha scritto nel messaggio
Not sure what you are asking. If you want a label to dissappear when a
field/control is null, consider changing the label to a text box. Set
the control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption part
and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet
that has a number of different types of items on it. There are about
50 choices and currently I have a text field and a label for each
field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is
there a way to hide text labels as well as the fields?
Thank you
Michael

 

[Michael]

Duane,
There are some fields that are just for one product such as tomatoes.
I also have a field for "product".
The reason did this is that most of the orders are for a full pallet. But
some orders are mixed pallets and there has to be a way to put a count of
the items that make up that pallet.
I thought of just having a check box to indicate a pallet and making a new
line for each product, but i have to make a report that shows all the
products on the mixed pallets.
Can you suggest a better way to design this table? I am still in the
construction phase of the forms and reports and there is no data, so I can
change it now with little loss of time.

thank you
Michael

Thank you very much.
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.

If you have a field named Tomatoes then I think your table structure
needs modification.

--
Duane Hookom
MS Access MVP
--

Thank you Duane,
I do not understand how to hide the value and the label this way. I
guess I did not explain well enough.

On the report,I have two sections for each order, one for when and order
is for a full pallet of one type of product and the other part is for a
mixed pallet.
In the first part is a line of info for a single product pallet, when it
is a mixed pallet, I have many fields such as a text box for the amount
of tomatoes and a label that says tomatoes. I would like to only show
the label and the amount for the products that are not null. Currently I
have all the labels showing all the time.

The alternative and preferred way is to show all the labels and values
only when the choice in the Product dropdown list is "Mixed Pallet"
Otherwise, each item has a line with the full information and the items
for the mixed order would be hidden.

"Duane Hookom" <[email protected]> ha scritto nel messaggio
A control set to allow shrinking will not show when null. The only way
that a text box will show if the value is null is if are displaying the
border or something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

"Duane Hookom" <[email protected]> ha scritto nel
messaggio Not sure what you are asking. If you want a label to dissappear when
a field/control is null, consider changing the label to a text box.
Set the control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption
part and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a pallet
that has a number of different types of items on it. There are about
50 choices and currently I have a text field and a label for each
field.

They all show all the time even though I use "mixed" very little. Is
there a way to only show these fields when they have content? Is
there a way to hide text labels as well as the fields?
Thank you
Michael

 

[Duane Hookom]

I suggest you search google groups on bill of materials or something
similar. If you don't find valuable information, post a question to an
appropriate news group such as the tablesdbdesign ng.

--
Duane Hookom
MS Access MVP
--

Duane,
There are some fields that are just for one product such as tomatoes.
I also have a field for "product".
The reason did this is that most of the orders are for a full pallet. But
some orders are mixed pallets and there has to be a way to put a count of
the items that make up that pallet.
I thought of just having a check box to indicate a pallet and making a new
line for each product, but i have to make a report that shows all the
products on the mixed pallets.
Can you suggest a better way to design this table? I am still in the
construction phase of the forms and reports and there is no data, so I can
change it now with little loss of time.

thank you
Michael

Thank you very much.
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.

If you have a field named Tomatoes then I think your table structure
needs modification.

--
Duane Hookom
MS Access MVP
--

Thank you Duane,
I do not understand how to hide the value and the label this way. I
guess I did not explain well enough.

On the report,I have two sections for each order, one for when and
order is for a full pallet of one type of product and the other part is
for a mixed pallet.
In the first part is a line of info for a single product pallet, when
it is a mixed pallet, I have many fields such as a text box for the
amount of tomatoes and a label that says tomatoes. I would like to
only show the label and the amount for the products that are not null.
Currently I have all the labels showing all the time.

The alternative and preferred way is to show all the labels and values
only when the choice in the Product dropdown list is "Mixed Pallet"
Otherwise, each item has a line with the full information and the items
for the mixed order would be hidden.

"Duane Hookom" <[email protected]> ha scritto nel messaggio
A control set to allow shrinking will not show when null. The only way
that a text box will show if the value is null is if are displaying the
border or something else.

--
Duane Hookom
MS Access MVP
--

Thanks Duane,
Can you tell me how I set the control or field to not show when null?
Michael

"Duane Hookom" <[email protected]> ha scritto nel
messaggio Not sure what you are asking. If you want a label to dissappear when
a field/control is null, consider changing the label to a text box.
Set the control source to something like:
="Spouse Name " + [SpouseName]
Make sure the text box is only wide enough to display the caption
part and set it to not grow.

--
Duane Hookom
MS Access MVP
--

I have a dropdown list that as one choice as "mixed" this is a
pallet that has a number of different types of items on it. There
are about 50 choices and currently I have a text field and a label
for each field.

They all show all the time even though I use "mixed" very little.
Is there a way to only show these fields when they have content? Is
there a way to hide text labels as well as the fields?
Thank you
Michael