Jim Hewson
JHewson at karta.com
Thu Sep 9 13:41:19 CDT 2004
What I meant was: are these two field's height equal to the height of the three fields combined? For example, if Name, FriendsName and Business each have a height of .17, does WAddress and/or TotAmount's height equal .51 (.17 * 3)? If it does and WAddress or TotAmount has anything in them, neither FriendsName or Business will shrink, even if Waddress has only one line in it. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of augusta Sent: Thursday, September 09, 2004 1:12 PM To: 'Access Developers discussion and problem solving' 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com