[AccessD] Shrinking fields in a report

Augusta,

    If your problem persists despite trying out afresh on a brand new report, you can send a zipped extract of your db containing the said report as well as the source tables & queries. 

    The number of records may please be pruned down so as to demonstrate the problem while keeping down the size.

A.D.Tejpal
( adtp at touchtelindia.net )

  ----- Original Message ----- 
  From: augusta 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, September 09, 2004 23:41
  Subject: RE: [AccessD] Shrinking fields in a report

  >Is the WAddress and TotAmount enlarged to cover the entire space?

  No,I am confused. What entire space?

  >I have sized two fields like FriendsName and Business to .0007 height and
  placed them close together with the CanGrow set to true.  In this case, when
  there is a Business without a FriendsName, business would appear to be
  directly under Name.

  All of the fields are the same height.  Friends Name and Business is the
  same length as Name

  augusta

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of augusta
  Sent: Thursday, September 09, 2004 12:24 PM
  To: 'Access Developers discussion and problem solving'
  Subject: RE: [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