Duane Hookom said: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 said: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?
Lyne Savage said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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 said: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
----------------------------------
Duane Hookom said: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 said: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 said: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
Lyne Savage said: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
----------------------------------
Duane Hookom said: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?