Re: How skip blank fields in Access Report?
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 16 May 2005 12:23:18 -0500
Blank fields are never displayed in a report unless you display their
border. The controls will always shrink if you have their Can Shrink
property to Yes and their value is Null/empty.
If you want to close up empty spaces in reports, you can only do this where
no other (non-shrinking) control is located to the left or right of the
control you want to shrink.
--
Duane Hookom
MS Access MVP
"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC1AB607-2BFF-4317-A190-C2A3B25E4EF6@xxxxxxxxxxxxxxxx
>I have a database with 18 fields. I have data for the first three fields
>in
> all records but only some records have any data in some of the remaining
> 15
> fields (and always different fields). How do I prepare a report that will
> only print the fields that have data? In other words, how do I get my
> Access
> Report to just skip all the blank fields in a particular record? I tried
> "can shrink" but it still gave me blanks.
>
> Thanks!
.
- References:
- How skip blank fields in Access Report?
- From: Ken
- How skip blank fields in Access Report?
- Prev by Date: How skip blank fields in Access Report?
- Next by Date: Re: Problem with PK's in report
- Previous by thread: How skip blank fields in Access Report?
- Next by thread: Re: How skip blank fields in Access Report?
- Index(es):
Relevant Pages
|
