augusta
awithing at twcny.rr.com
Thu Sep 9 13:12:49 CDT 2004
>Is the section CanShrink property set to Yes? Yes, all fields in the whole section and the section itself are set to shrink. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of augusta Sent: Thursday, September 09, 2004 10:24 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Shrinking fields in a report Yes I do have fields on the same line and they are all set to CanShrink. There are no labels. . . Still does not shrink. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Thursday, September 09, 2004 7:30 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Shrinking fields in a report If you have fields on the same line, then the line won't be able to shrink unless all the fields can shrink. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of augusta Sent: Wednesday, September 08, 2004 2:11 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Shrinking fields in a report I have a report that contains basic info - Memname, business name, friends name, address, and total sum contributed. In the report I have on the left hand side name, business, friends name. The middle (ideally on the same line) address, and then alittle over (once again on the same line) is the Total Sum. I have set all the fields to shrink, but when there is only a business and friend name to the record, it does not shrink all the way. But when there is a Memname and friend name, it does. This is a mystery. Any clues? IS there a limit to the number of fields that can shrink? Thanks Augusta____________