visible only if data is recorded

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

Guest

Is it possible to setup a report control to display only if data is recorded
in it's control source?
 
Sure. I would guess you are saying that the report leaves blank vertical
space even if there is nothing in the field? If so, set the item's "can
shrink" property to "true". Assuming it is the only control in that
vertical space (nothing to the left or right) it will only appear (and take
up space) when data exists.

Please note, this is asked and answered all the time. In the future, I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the "groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.
 
Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the controls. So I
guess my more accurate question is: Can labels be set to appear only if data
is recorded in their associated controls?

Thanks!
 
As Rick suggests this question is asked quite often. My standard answer is
to change the label to a text box and set its control source to something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.
 
Thanks, Duane. I checked this out and it works fine. Pretty slick. However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in columns.
The first column is an attribute column and it contains labels that describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you suggest?

Thanks!

--
www.Marzetti.com


Duane Hookom said:
As Rick suggests this question is asked quite often. My standard answer is
to change the label to a text box and set its control source to something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.
Click to expand...
 
My experience with searching for answers via the paths you've suggested have
never been positive nor productive. I spend way too much time searching when
I can simply post here and be done.
 
My suggestion didn't get rid of your previous "value" text box. The new
"label" text box should not show the value, only the former label value.
="Style " + [StyleField]
The above text box should only show the word "Style" and not the value from
the field.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Thanks, Duane. I checked this out and it works fine. Pretty slick.
However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in
columns.
The first column is an attribute column and it contains labels that
describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you
suggest?

Thanks!

--
www.Marzetti.com


Duane Hookom said:
As Rick suggests this question is asked quite often. My standard answer
is
to change the label to a text box and set its control source to something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.

--
Duane Hookom
MS Access MVP
--

JohnLute said:
Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what
you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the controls.
So I
guess my more accurate question is: Can labels be set to appear only if
data
is recorded in their associated controls?

Thanks!

--
www.Marzetti.com


:

Sure. I would guess you are saying that the report leaves blank
vertical
space even if there is nothing in the field? If so, set the item's
"can
shrink" property to "true". Assuming it is the only control in that
vertical space (nothing to the left or right) it will only appear (and
take
up space) when data exists.

Please note, this is asked and answered all the time. In the future,
I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the
"groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.


--
Rick B



Is it possible to setup a report control to display only if data is
recorded
in it's control source?
Click to expand...
Click to expand...
Click to expand...
 
Something's not right. I've been trying this with a control source named
2FluteType:

="Flute Type"+[2FluteType]

I enter in the value B and the report returns:
Flute TypeB

What am I missing?

--
www.Marzetti.com


Duane Hookom said:
My suggestion didn't get rid of your previous "value" text box. The new
"label" text box should not show the value, only the former label value.
="Style " + [StyleField]
The above text box should only show the word "Style" and not the value from
the field.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Thanks, Duane. I checked this out and it works fine. Pretty slick.
However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in
columns.
The first column is an attribute column and it contains labels that
describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you
suggest?

Thanks!

--
www.Marzetti.com


Duane Hookom said:
As Rick suggests this question is asked quite often. My standard answer
is
to change the label to a text box and set its control source to something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.

--
Duane Hookom
MS Access MVP
--

Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what
you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the controls.
So I
guess my more accurate question is: Can labels be set to appear only if
data
is recorded in their associated controls?

Thanks!

--
www.Marzetti.com


:

Sure. I would guess you are saying that the report leaves blank
vertical
space even if there is nothing in the field? If so, set the item's
"can
shrink" property to "true". Assuming it is the only control in that
vertical space (nothing to the left or right) it will only appear (and
take
up space) when data exists.

Please note, this is asked and answered all the time. In the future,
I'd
suggest you search for your answers before posting a new thread. The
easiest way I have found is to go to www.google.com, click the
"groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.


--
Rick B



Is it possible to setup a report control to display only if data is
recorded
in it's control source?
Click to expand...
Click to expand...
Click to expand...
 
Where are all the spaces that I had included?
="Flute Type "+[2FluteType]

The "label" text box shoul be wide enough to only display the label:
"Flute Type"
and not display the value from the field [2FluteType].
The value from the field is displayed in a separate text box to the right of
the "label" text box.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Something's not right. I've been trying this with a control source named
2FluteType:

="Flute Type"+[2FluteType]

I enter in the value B and the report returns:
Flute TypeB

What am I missing?

--
www.Marzetti.com


Duane Hookom said:
My suggestion didn't get rid of your previous "value" text box. The new
"label" text box should not show the value, only the former label value.
="Style " + [StyleField]
The above text box should only show the word "Style" and not the value
from
the field.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Thanks, Duane. I checked this out and it works fine. Pretty slick.
However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in
columns.
The first column is an attribute column and it contains labels that
describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you
suggest?

Thanks!

--
www.Marzetti.com


:

As Rick suggests this question is asked quite often. My standard
answer
is
to change the label to a text box and set its control source to
something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it
to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.

--
Duane Hookom
MS Access MVP
--

Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what
you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the
controls.
So I
guess my more accurate question is: Can labels be set to appear only
if
data
is recorded in their associated controls?

Thanks!

--
www.Marzetti.com


:

Sure. I would guess you are saying that the report leaves blank
vertical
space even if there is nothing in the field? If so, set the item's
"can
shrink" property to "true". Assuming it is the only control in
that
vertical space (nothing to the left or right) it will only appear
(and
take
up space) when data exists.

Please note, this is asked and answered all the time. In the
future,
I'd
suggest you search for your answers before posting a new thread.
The
easiest way I have found is to go to www.google.com, click the
"groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.


--
Rick B



Is it possible to setup a report control to display only if data
is
recorded
in it's control source?
Click to expand...
Click to expand...
Click to expand...
 
I see. I got confused with the value showing up in the text field and
couldn't see the problem clearly. I now have it all formatted properly and it
works fine. Great solution! It probably wold've taken me 2 days of searching
to find this covered somewhere else.

Wow - I've got A LOT of re-formatting to do!

Is it easier to put all the spaces in? I just used 2 spaces and it works OK.

--
www.Marzetti.com


Duane Hookom said:
Where are all the spaces that I had included?
="Flute Type "+[2FluteType]

The "label" text box shoul be wide enough to only display the label:
"Flute Type"
and not display the value from the field [2FluteType].
The value from the field is displayed in a separate text box to the right of
the "label" text box.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Something's not right. I've been trying this with a control source named
2FluteType:

="Flute Type"+[2FluteType]

I enter in the value B and the report returns:
Flute TypeB

What am I missing?

--
www.Marzetti.com


Duane Hookom said:
My suggestion didn't get rid of your previous "value" text box. The new
"label" text box should not show the value, only the former label value.
="Style " + [StyleField]
The above text box should only show the word "Style" and not the value
from
the field.
--
Duane Hookom
MS Access MVP
--


Thanks, Duane. I checked this out and it works fine. Pretty slick.
However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in
columns.
The first column is an attribute column and it contains labels that
describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you
suggest?

Thanks!

--
www.Marzetti.com


:

As Rick suggests this question is asked quite often. My standard
answer
is
to change the label to a text box and set its control source to
something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it
to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.

--
Duane Hookom
MS Access MVP
--

Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what
you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the
controls.
So I
guess my more accurate question is: Can labels be set to appear only
if
data
is recorded in their associated controls?

Thanks!

--
www.Marzetti.com


:

Sure. I would guess you are saying that the report leaves blank
vertical
space even if there is nothing in the field? If so, set the item's
"can
shrink" property to "true". Assuming it is the only control in
that
vertical space (nothing to the left or right) it will only appear
(and
take
up space) when data exists.

Please note, this is asked and answered all the time. In the
future,
I'd
suggest you search for your answers before posting a new thread.
The
easiest way I have found is to go to www.google.com, click the
"groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.


--
Rick B



Is it possible to setup a report control to display only if data
is
recorded
in it's control source?
Click to expand...
Click to expand...
Click to expand...
 
Well, I started re-designing some things and immediately noticed that the
text boxes work fine, however, the report left gaps where the text boxes
would normally be when they have data.

I looked at the shrink properties of the report and realized I had it set to
true for grow. I changed it to false and the gaps disappear.

This is a major design change that will sure enhance my reports.

Thanks for your help!

--
www.Marzetti.com


Duane Hookom said:
Where are all the spaces that I had included?
="Flute Type "+[2FluteType]

The "label" text box shoul be wide enough to only display the label:
"Flute Type"
and not display the value from the field [2FluteType].
The value from the field is displayed in a separate text box to the right of
the "label" text box.
--
Duane Hookom
MS Access MVP
--


JohnLute said:
Something's not right. I've been trying this with a control source named
2FluteType:

="Flute Type"+[2FluteType]

I enter in the value B and the report returns:
Flute TypeB

What am I missing?

--
www.Marzetti.com


Duane Hookom said:
My suggestion didn't get rid of your previous "value" text box. The new
"label" text box should not show the value, only the former label value.
="Style " + [StyleField]
The above text box should only show the word "Style" and not the value
from
the field.
--
Duane Hookom
MS Access MVP
--


Thanks, Duane. I checked this out and it works fine. Pretty slick.
However,
I'd like to maintain the fixed alignment of my report format and the
suggestion results in misalignment. For example, I have my report in
columns.
The first column is an attribute column and it contains labels that
describe
attributes:

ATTRIBUTES | VALUE
-------------------------
Style | 0201 Regular Slotted Container
ID Length | 18.4375
ID Width | 7.5
ID Height | 8.0

If I use your method then the columns become misaligned:

ATTRIBUTES | VALUE
-------------------------
Style: 0201 Regular Slotted Container
ID Length: 18.4375
ID Width: 7.5
ID Height: 8.0

Is there any way to maintain fixed column widths using the method you
suggest?

Thanks!

--
www.Marzetti.com


:

As Rick suggests this question is asked quite often. My standard
answer
is
to change the label to a text box and set its control source to
something
like:
="Last Name: " + [LastNameField]
Make the control only wide enough to display "Last Name:" and allow it
to
shrink but not grow.

If [LastNameField] is null, the "label" will disappear.

--
Duane Hookom
MS Access MVP
--

Thanks, Rick.

Actually, I wasn't as clear as I could've been. The key here is what
you
noted: "Assuming it's the only control in that vertical space."

This is my problem. My vertical lines include labels to the
controls.
So I
guess my more accurate question is: Can labels be set to appear only
if
data
is recorded in their associated controls?

Thanks!

--
www.Marzetti.com


:

Sure. I would guess you are saying that the report leaves blank
vertical
space even if there is nothing in the field? If so, set the item's
"can
shrink" property to "true". Assuming it is the only control in
that
vertical space (nothing to the left or right) it will only appear
(and
take
up space) when data exists.

Please note, this is asked and answered all the time. In the
future,
I'd
suggest you search for your answers before posting a new thread.
The
easiest way I have found is to go to www.google.com, click the
"groups"
options, and enter a search string starting with the following...

microsoft.public.access

followed by search keywords.


--
Rick B



Is it possible to setup a report control to display only if data
is
recorded
in it's control source?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top