[AccessD] Shrinking fields in a report

Could it be that an empty string is being passed in one or more of the
fields in instead of a null?

Bobby

-----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____________