[AccessD] Shrinking fields in a report

Thanks for your reply

But none of the fields are touching each other

This is how it is set up:

IDNo 	Name			WAddress	TotAmount
	FriendsName
	Business

Thats it! And nothing touches, all are set to CanShrink! FriendsName and
Business do not shrink up. But, where there is no FriendsName or Business,
the white space goes away.

I'm stumped. Am I asking it to do something it can't do?

Thanks Augusta

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Elam, Debbie
Sent: Thursday, September 09, 2004 12:25 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Shrinking fields in a report

I have seen strange shrink behavior when fields are touching other fields,
or even overlap the same (imaginary) parallel line.  Make sure the fields
are even across the top, or outside the space of fields with data.  Then
make sure a field with data is not touching it anywhere.  I had one rather
crowded report where this was a culprit.  The edges were supposed to just
barely touch, but they actually overlapped slightly.

Debbie

-----Original Message-----
From: augusta [mailto:awithing at twcny.rr.com] 
Sent: Wednesday, September 08, 2004 1: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