conteHome > Ms Access > Ms Access Report Can Shrink Not Working

Ms Access Report Can Shrink Not Working

MikeAngelastro View Public Profile Visit MikeAngelastro's homepage! If the contents of the memo field exceed the size of the control we need to "Zoom" the control to see everything. It's quick & easy. "Can Shrink" isnt shrinking on report P: n/a John Baker Hi: I have a report that contains a remarks field which is a "memo" format field. If there are many Child reports based on separate tables then a grouped report is not practical ;-) OK, so lets do this... this contact form

Again thanks for your help. PC Learning Zone - Computer Training 311,148 views 10:30 Using Columns in Microsoft Access Reports - Duration: 7:57. The subreports grow and shrink just fine, and when the subreport has no data it does not display. First off, I have never seen "Can Shrink" work, but I have seen "Can Grow" work.

Note The CanShrink property does not apply to form or report page header and page footer sections, although it does apply to controls in such sections. The detail section can not shrik if none of the text boxes are set to can shrimk.« Next Oldest· Access Reports· Next Newest »Display Mode: Standard · Switch to: · Switch Loading...

That is, when it is time to shrink, they shink to nothing and the upper and lower text boxes actually touch. Have it fill nearly all of the vertical space between your text boxes. Frank Martin, Jan 12, 2005, in forum: Microsoft Access Reports Replies: 0 Views: 210 Frank Martin Jan 12, 2005 How can I force all fields to grow to the largest "can Unstructured Feedback Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox for IT on Twitter on Twitter on

What page are you on in that screenshot? Try Free For 30 Days Join & Write a Comment Already a member? If one text box contains one line of data and the other text box contains two lines of data, both text boxes will be two lines long because the section is When you post a sample database, please include explicit instructions on how to use it. (I don't see any report there with 11 subreports...?) 5.

It is not clear from your question title: "Report: Shrink does not work" ...which "Shrink" property you are referring to, ... The reason I have this issue is because we are using the following fields: Supplier Contact Name Suite Street City, ST, and ZIP Both the Contact Name and Suite fields can Ask a vague question, get a vague answer.Find out how to get great answers FAQ219-2884. Sign in to make your opinion count.

Remarks The CanShrink property uses the following settings. This Site TextBox.CanShrink Property (Access) Office 2013 and later Other Versions Office 2010 Contribute to this content Use GitHub to suggest and submit changes. There can be no overlap in design view if you want > CanGrow to work properly. > > -- > I don't check the Email account attached > to this message. Click Here to join Tek-Tips and talk with other members!

All rights reserved. RE: Need to shrink detail section of report Cosette (TechnicalUser) (OP) 3 Nov 06 06:32 Duane,Thank you for all your work on this issue. I always like to know when a record has been updated, so by having a popup form, you can set the LastUpdated field to Now() if any update to the comments There was no indication that you were testing one control and setting another visible.

Its notshrinking! Thread Tools Rate Thread Display Modes 03-11-2003, 03:33 PM #1 MikeAngelastro Registered User Join Date: Mar 2000 Location: Salt Lake, Utah Posts: 254 Thanks: 0 Thanked 0 Times in Sign in Share More Report Need to report the video? However, I did what you said and the Detail section does not shrink when there is no data in the field.

Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Loading... Thanks again.

Any other ideas??? "Rick Brandt" wrote: > naiveprogrammer wrote: > > I doubled checked- they are not touching at all.

Mike MikeAngelastro View Public Profile Visit MikeAngelastro's homepage! If you're having a computer problem, ask on our forum for advice. Join UsClose It tends to look normal when all the text boxes have data.

What happened to drawing line between the subreports so I could see Go to Solution 13 9 2 Participants TimothyA(13 comments) Jeffrey Coachman(9 comments) LVL 74 MS Access72 23 Comments Thanks your your continuing help with my issues. Sign in Transcript 2,665 views 15 Like this video? Regards JOhn Baker Nov 12 '05 #1 Post Reply Share this Question 2 Replies P: n/a Tom van Stiphout On Fri, 16 Jan 2004 13:31:50 GMT, John Baker wrote: The

To obtain report results for 4 queries: RptQry01BS_All_Com, RptQry0BS_All_Com_NoLabel, RptQry01BS_Ns, and RptQry01BS_Nz_Show Labels. This documentation is archived and is not being maintained. I know it sounds like there is something (spaces?) in the field, but allother indications are that it is really empty (null).Any suggestions?RegardsJOhn Baker Nov 12 '05 #3 This discussion thread When you set the property to Yes, the object automatically adjusts so any amount of data can be printed.

If you set a control's CanShrink property to Yes, Microsoft Access does not set the section's CanShrink property to Yes. I find the use of the scroll bars a very easy & uncomplicated solution. You can use this property to control the appearance of printed forms and reports. Hello and welcome to PC Review.

How do I go about the detail section to shrink and not include txtspouse when the value is null?Thank you RE: Need to shrink detail section of report dhookom (Programmer) 30 I rarely use subreports unless it is the only way to get the output I need. These are examples of when bill-to and ship-to fields are side-by-side. This tutorial explains the problem and how to fix it...