Printing - Data Only

[Lyne Savage]

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Duane Hookom]

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

 

[Lyne Savage]

no, that should work, thanks. The reason why some reports have blank values
is that the length of the reports, and the details, varies.

 

[Lyne Savage]

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

 

[Duane Hookom]

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

 

[Lyne Savage]

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

 

[Duane Hookom]

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Lyne Savage]

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Duane Hookom]

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Lyne Savage]

I want to set Can Shrink to yes so that no data makes the box disappear, but
I don't want them to shrink to fit to the data size. I have several bordered
boxes in rows, and they all line up. When there is only one line of text in
one box, and 5 lines in the other, my rows don't line up anymore. Get what I
mean?

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP


:

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Duane Hookom]

Did these line up before? I can't understand how a text box dissappearing
will affect borders of other text boxes. Can you illustrate your issue by
typing in a few records?

--
Duane Hookom
Microsoft Access MVP

I want to set Can Shrink to yes so that no data makes the box disappear, but
I don't want them to shrink to fit to the data size. I have several bordered
boxes in rows, and they all line up. When there is only one line of text in
one box, and 5 lines in the other, my rows don't line up anymore. Get what I
mean?

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

:

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP


:

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Lyne Savage]

it's not the disappearing text that is causing a problem. CanShrink shrinks
my borders when the box is not completely filled with text.

ex> COLUMN A COLUMN B
text line 1 text line 1
text line 2 --------------- <
-------------
I need the borders to stay like this:
COLUMN A COLUMN B
text line 1 text line 1
text line 2
----------------------------------

Did these line up before? I can't understand how a text box dissappearing
will affect borders of other text boxes. Can you illustrate your issue by
typing in a few records?

--
Duane Hookom
Microsoft Access MVP

I want to set Can Shrink to yes so that no data makes the box disappear, but
I don't want them to shrink to fit to the data size. I have several bordered
boxes in rows, and they all line up. When there is only one line of text in
one box, and 5 lines in the other, my rows don't line up anymore. Get what I
mean?

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP


:

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

:

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP


:

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Duane Hookom]

Is this a multi-column report?
Are you showing one record in your display or is this two records?

Since this looks like a single horizontal line, I think you could use a line
control under the text boxes.
--
Duane Hookom
Microsoft Access MVP

it's not the disappearing text that is causing a problem. CanShrink shrinks
my borders when the box is not completely filled with text.

ex> COLUMN A COLUMN B
text line 1 text line 1
text line 2 --------------- <
-------------
I need the borders to stay like this:
COLUMN A COLUMN B
text line 1 text line 1
text line 2
----------------------------------

Did these line up before? I can't understand how a text box dissappearing
will affect borders of other text boxes. Can you illustrate your issue by
typing in a few records?

--
Duane Hookom
Microsoft Access MVP

I want to set Can Shrink to yes so that no data makes the box disappear, but
I don't want them to shrink to fit to the data size. I have several bordered
boxes in rows, and they all line up. When there is only one line of text in
one box, and 5 lines in the other, my rows don't line up anymore. Get what I
mean?

:

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP


:

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

:

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP


:

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?

 

[Lyne Savage]

I am going to re-thread this to see what else I can get. Thanks.

Is this a multi-column report?
Are you showing one record in your display or is this two records?

Since this looks like a single horizontal line, I think you could use a line
control under the text boxes.
--
Duane Hookom
Microsoft Access MVP

it's not the disappearing text that is causing a problem. CanShrink shrinks
my borders when the box is not completely filled with text.

ex> COLUMN A COLUMN B
text line 1 text line 1
text line 2 --------------- <
-------------
I need the borders to stay like this:
COLUMN A COLUMN B
text line 1 text line 1
text line 2
----------------------------------

Did these line up before? I can't understand how a text box dissappearing
will affect borders of other text boxes. Can you illustrate your issue by
typing in a few records?

--
Duane Hookom
Microsoft Access MVP


:

I want to set Can Shrink to yes so that no data makes the box disappear, but
I don't want them to shrink to fit to the data size. I have several bordered
boxes in rows, and they all line up. When there is only one line of text in
one box, and 5 lines in the other, my rows don't line up anymore. Get what I
mean?

:

I'm not sure what you are referring to with "Is there a way to keep certain
boxes a certain size?" You can set a control's Can Grow and Can Shrink
properties to No.

--
Duane Hookom
Microsoft Access MVP


:

ok, so that works, thank you. Now, they disappear when blank. But when there
is data in the field, it shrinks to fit that data. If the field next to it
(which corresponds with the first field) the column borders no longer line
up...one of the text boxes becomes smaller than the other. Is there a way to
keep certain boxes a certain size?

:

Don't use dropdown lists in reports if you want the controls to shrink. You
may need to add the Row Source from the dropdowns to the reports record
source.

--
Duane Hookom
Microsoft Access MVP


:

what I mean is, the ones that don't shrink are drop down lists...the ones
that shrink are not.

any help for me?

:

I'm not sure what you mean by "text fields". Can we assume you mean text box
controls? And by "others", you mean label controls? Labels don't shrink but
you can generally replace a label with a text box and set its control source
to something like:
="Maiden Name: " + [MaidenName]
If the field is null, the entire expression will be null.

--
Duane Hookom
Microsoft Access MVP


:

ok...so I can do it for some fields and not others...is this because they are
text fields? I have several fields side by side (they have to stay there)
some that dont have Can Shrink and some that do...those that do seem to be
the text fields. Can i change the others to text?

:

You can set the Can Shrink property of a text box to Yes and it will
disappear if it is Null. If this doesn't answer your question then you need
to provide more information.

I fear you may have table structure issues if you have a number of
blank/empty fields. I could be wrong.

--
Duane Hookom
Microsoft Access MVP


:

Have a nice report that I can't possibly fit onto one page...but what if I
can print only data, and leave the blanks invisible? Is this possible?