If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing - Data Only
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? |
#2
|
|||
|
|||
Printing - Data Only
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? |
#3
|
|||
|
|||
Printing - Data Only
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? |
#4
|
|||
|
|||
Printing - Data Only
no, that should work, thanks. The reason why some reports have blank values
is that the length of the reports, and the details, varies. "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? |
#5
|
|||
|
|||
Printing - Data Only
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? |
#6
|
|||
|
|||
Printing - Data Only
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? |
#7
|
|||
|
|||
Printing - Data Only
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? |
#8
|
|||
|
|||
Printing - Data Only
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? |
#9
|
|||
|
|||
Printing - Data Only
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? |
#10
|
|||
|
|||
Printing - Data Only
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? |
|
Thread Tools | |
Display Modes | |
|
|