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

Ms Access Report Can Shrink Not Working

Thanks again. Evolution of End User Computing--Evolving to Better Meet ... Its not shrinking! Join UsClose Check This Out

In any event... The problem with using Shift-F2 to zoom is that as soon as you zoom, the text can be highlighted and any character pressed will delete its contents. You have answered this question through example. 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

This is how video conferencing should work! Only fields with field names ending in “_Com” will be in the selection pool. The Detail section is set to Can Grow as well as > > Can Shrink.

The Detail section is set to Can Grow as well as Can Shrink. What happened to drawing line between the subreports so I could see where they begin and end? Registration on or use of this site constitutes acceptance of our Privacy Policy. MindXPanse 48,962 views 18:08 Microsoft Office Access 2010-Set the record source for a form or report.

I have studied the sample file you sent me earlier(Database128.mdb). 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 Ever have a problem with the Can Shrink property in your Microsoft Access database reports? code from your report?6) Did you leave the border of the text box showing?7) If you answered Yes to 4, 5, & 6 did the border disappear for Null values?

You can add and view as much as you want within this field. Please Wait... Explain the structure of this report so it is clear why 11 subreports are needed. 4. Could that be the problem?Thanks RE: Need to shrink detail section of report dhookom (Programmer) 1 Nov 06 22:31 You shouldn't need any code.

Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Second. You'll be able to ask any tech support questions, or chat with the community and help others. Hey, thanks for the feedback ;-) My plan was to see if the report could be grouped.

Hope this helps, Regards Barb Colpitts, bsac Business Systems Analyst, Material Management Governance, Controls and Strategies Part Logistics - Bombardier Aerospace Top Best Answer 0 Mark this reply as the best his comment is here Related Evolution of End User Computing--Evolving to Better Meet ... I have formatted it to two columns. I would like to have the equivalent of cangrow and canshrink for the memo field.

Are you aComputer / IT professional?Join Tek-Tips Forums! Or aline control?-Tom.Hi:I have a report that contains a remarks field which is a "memo" format field. The Detail section is set to Can Grow as well as > Can Shrink. http://amptools.net/ms-access/ms-access-nz-not-working.html The properties ONLY apply to the virtical space occupied by a control.

If I leave an extra 1 inch of blank in the detail section, it doesn't shrink, even when I select can shrink for both the text box and the detail section!Thanks Similar topics "Can grow" Fields height in report Can "all bits zero" be a trap representation for integral types? PC Learning Zone - Computer Training 311,148 views 10:30 Using Columns in Microsoft Access Reports - Duration: 7:57.

Category Education License Standard YouTube License Show more Show less Loading...

I set the event for 'on Format'. Send instead to... The question at least to me seem to be and should have been earlier, if I had been wise enough to understand the core issue, can empty fields with "text labels Many of the fields are do not have visible information/empty (I loose tack of empty, no data, null, no string, empty string) Report: Present “RptQryCom” was to have header of fields

In closing, is seems to me I should start over. Use a control source like:=IIf(IsNull(SpouseID),Null," ")Set the font of this text box to very large and set it to can shrink. What page are you on in that screenshot? navigate here Any tricks you know to get around this limitation?

What page are you on in that screenshot? Send instead to... The time now is 04:48 AM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored Yet I still am > > having the same issue. ??? > > Are there any controls to the sides of the ones you expect to grow/shrink? > A control cannot

I have thatfield on a single line in the report, and have it given a property of "Can Shrink", in thehope that he line will vanish when there is no data Working... How is the best way to change this to you? Find More Posts by MikeAngelastro

03-11-2003, 09:39 PM #4 Pat Hartman Super Moderator Join Date: Feb 2002 Location: Stratford,Ct USA Posts: 25,623 Thanks: 12 Thanked

When you set the property to Yes, the object automatically adjusts so any amount of data can be printed. I then set up my detail section with first name and an inch below last name. I have to leave work now. RE: Need to shrink detail section of report dhookom (Programmer) 3 Nov 06 10:45 That is why I stated about 4 days ago "Don't expect vertical gaps between controls to go

Neither subreport srpt05 and srpt06 which have completely empty groupings shrink. It'll look something like: The BillToAddress field: =BillToCompanyName & vbCrLf & IIf(IsNull(BillToAddr2), BillToAddr1, BillToAddr1 & vbCrLf & BillToAddr2) & vbCrlf & BillToCity & ", " & BillToState & " " & Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. I have all text boxes to Can Grow as well as Can Shrink.

Using CanShrink or CanGrow properties in a form using Access 2003 Paul Dick asked Mar 31, 2010 | Replies (7) I have a table with basically 2 fields: a subject and