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.
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.
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
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
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