 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006blank lines in the address block
I know when I'm using Word for a Mail Merge that it is possible to have both fields NOT print if there is no data in them. For instance the database has Address1 and Address2. If one record DOES have both then a '4 line' address will result. If another record DOES NOT have data in Address2 then not only is there no data but the address block will be reduced to '3 lines' making a more aesthetically pleasing look. Due to the nature of this particular project I need to have this particular letter set up as an Access report for the grouping of records on the Customer Number. Does Access have any functionality that will allow for the 3 line - 4 line difference without resorting (as I already have) to creating separate reports. One report has BOTH Address1 AND Address2 and the other only has Address1. Windows XP Office 2002 AND Office 2003 Dave French Set the Can Shrink property of your text boxes to Yes. Unless there is something else that overlaps the control vertically, it will effectively become zero-height when null.  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I know when I'm using Word for a Mail Merge that it is possible to have >both fields NOT print if there is no data in them. [quoted text clipped - 15 lines] > Windows XP > Office 2002 AND Office 2003 OK.... I tried that setting both boxes properties to "Can Shrink". Now how is the text box underneath supposed to move UP to take up the space? Or, do I make one box that has both items in it. For instance Address1 & Address2. If one or the other is null then the space would be reduced, correct? Now that I've said that....how would I get Address1 and Address2 to reside on 2 separate lines in that case? Dave French > Set the Can Shrink property of your text boxes to Yes. > [quoted text clipped - 20 lines] >> Windows XP >> Office 2002 AND Office 2003 Try it, David. Or use the Report Wizard for Labels to get Access to create an example for you. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > OK.... > I tried that setting both boxes properties to "Can Shrink". [quoted text clipped - 34 lines] >>> Windows XP >>> Office 2002 AND Office 2003 How do you force a line return inside a text box? I have tried a simple press of the Enter button but that only ends my editing. I have tried a ^p and a ^l to no avail. The Report Wizard was no help either. Any other suggestions? Dave French > Try it, David. > [quoted text clipped - 39 lines] >>>> Windows XP >>>> Office 2002 AND Office 2003 Hi David, In the Other section of the text box properties there is a property called "Enter Key Behavior." Change it to "New Line in Field." Cheers. SignatureKen Hudson > How do you force a line return inside a text box? > I have tried a simple press of the Enter button but that only ends my [quoted text clipped - 49 lines] > >>>> Windows XP > >>>> Office 2002 AND Office 2003 For this case, you are probably better off using separate text boxes, so they Can Shrink. It can get more messy where you are combining several fields with optional line breaks. If you want to do it anyway, you need to add a Carriage Return and Line Feed: =[Address1] & Chr(13) & Chr(10) & [Address2] SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > How do you force a line return inside a text box? > I have tried a simple press of the Enter button but that only ends my [quoted text clipped - 49 lines] >>>>> Windows XP >>>>> Office 2002 AND Office 2003 I'm really not seeing any of this working at ALL. I have tried all of these suggestions (not the <CR> or <LR> yet) but I don't see how the shrinking is helping at all. I still end up with a space where I don't WANT a space. I hope this works out on here as far as attempting to visually describe what I'm seeing. Dave French 123 Somewhere Street Suite 99 Anywhere, NY 12345 Now...even if I tell the text box that contains the "Suite 99" to shrink I still end up with: Dave French 123 Somewhere Street Anywhere, NY 12345 OK...the box shrank....but the City, ST ZIP box has no instruction to move UP. Still Confused, Dave > For this case, you are probably better off using separate text boxes, so > they Can Shrink. It can get more messy where you are combining several [quoted text clipped - 57 lines] >>>>>> Windows XP >>>>>> Office 2002 AND Office 2003 It does work, David. To see an example, open the Northwind sample database, and run the Customer Labels report. The report shows address boxes shinking and growing according to the data in the Customers table. You can delete everything in the Address field for customer: Cactus Comidas para llevar to see the "Buenos Aires 1010" move right up under the customer name. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > I'm really not seeing any of this working at ALL. > I have tried all of these suggestions (not the <CR> or <LR> yet) but I [quoted text clipped - 84 lines] >>>>>>> Windows XP >>>>>>> Office 2002 AND Office 2003 Well Allen, I have compared everything from 'soup to nuts' between both databases. The only thing that has worked at ALL is to copy the fields from the Northwind sample report and paste them into MY report and then changing the field names in the text boxes. This HAS finally worked although I don't see what parameter I missed. Copy and paste is easier anyway. Don't argue with SUCCESS!! Thank you for your help! Dave French > It does work, David. > [quoted text clipped - 94 lines] >>>>>>>> Windows XP >>>>>>>> Office 2002 AND Office 2003 David Take a look at the CanGrow/CanShrink properties, both of the [Address] controls AND the Detail section of the report definition. SignatureRegards Jeff Boyce <Office/Access MVP> > I know when I'm using Word for a Mail Merge that it is possible to have both > fields NOT print if there is no data in them. [quoted text clipped - 17 lines] > > Dave French |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.