Results 1 to 5 of 5
  1. #1
    radian89 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Dec 2015
    Posts
    37

    Can Shrink Problem, Couldn't Skip blank on Print preview (YELP!)

    Hi All,



    I have classic question, but I've tried all google solution, but i'm still confuse.
    I want to skip blank in my reports, but i can't. here's what i've been doing

    - set can shrink properties for all textboxes in detail part to YES
    - set can shrink properties in detail to YES
    - there's 1 textboxes to calculate total = sum ([Quantity]*[Price]) in the detail, set it Visible = NO, Can shrink = YES

    here's the screenshot of my reports
    this is displayed on report view
    Click image for larger version. 

Name:	Canshring reportview.JPG 
Views:	12 
Size:	25.1 KB 
ID:	23095

    this is displayed on design view
    Click image for larger version. 

Name:	Canshrink designview.JPG 
Views:	12 
Size:	22.0 KB 
ID:	23096

    this is displayed on print preview
    Click image for larger version. 

Name:	canshrink.JPG 
Views:	12 
Size:	22.3 KB 
ID:	23097

    what's to be the problem in my case? thanks a lot for the help

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Uploading your database (without confidential data of course) would greatly help us to help you.

  3. #3
    radian89 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Dec 2015
    Posts
    37
    Quote Originally Posted by cyanidem View Post
    Uploading your database (without confidential data of course) would greatly help us to help you.
    Hi cyanidem,

    sorry not attaching it... here we goes... thanks for the help.

    cheers
    Attached Files Attached Files

  4. #4
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    I'm not quite sure if I understood what you want to achieve, but if it's this:
    Click image for larger version. 

Name:	printttt.jpg 
Views:	10 
Size:	52.6 KB 
ID:	23099
    then you need to move controls from page footer to report footer and of course set report footer can shrink/can grow to yes.
    If not, then I may need some clearer explanation what is it you want to achieve.

  5. #5
    radian89 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Dec 2015
    Posts
    37
    Quote Originally Posted by cyanidem View Post
    I'm not quite sure if I understood what you want to achieve, but if it's this:
    Click image for larger version. 

Name:	printttt.jpg 
Views:	10 
Size:	52.6 KB 
ID:	23099
    then you need to move controls from page footer to report footer and of course set report footer can shrink/can grow to yes.
    If not, then I may need some clearer explanation what is it you want to achieve.
    Ohh gosh, how silly of me... I didn't think of it... lols....
    Thanks a lot cyanidem, that solve my problem... love u

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-29-2014, 01:05 PM
  2. Fields Go Blank On Print Preview
    By VariableZ in forum Reports
    Replies: 4
    Last Post: 03-07-2013, 11:00 AM
  3. Print preview problem
    By Delacour in forum Access
    Replies: 5
    Last Post: 01-09-2012, 01:26 PM
  4. Replies: 1
    Last Post: 01-10-2011, 01:08 PM
  5. Form print preview problem
    By kloss1a in forum Forms
    Replies: 3
    Last Post: 01-03-2011, 12:12 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums