Printing - Data Only

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?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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

any help for me?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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" wrote:

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


"Lyne Savage" wrote:

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?

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


"Lyne Savage" wrote:

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?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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

any help for me?

"Duane Hookom" wrote:

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


"Lyne Savage" wrote:

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" wrote:

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


"Lyne Savage" wrote:

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?