Results 1 to 12 of 12

Thread: Microsoft Access 2000 & printable copy list

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Super Moderator Super Moderator Big Booger's Avatar
    Join Date
    Apr 2002
    Location
    JAPAN
    Posts
    10,201
    Go to File>Print Merge. In the "Print Merge" dialog box, make sure that you have selected to "Don't print any lines that contain any empty fields (should be checked by default, so this should be ok).
    Not sure if that is an option for you in Access 2000.

    I don't have an access database to test this on, but it is worth a shot.

    You might have to import the access database into word to get this feature.. not 100% sure about it though.


    ONE OTHER THING

    Open the form or report in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
    Select the text box, and then click Properties on the toolbar.
    Set the CanGrow or CanShrink property to Yes.
    CanGrow expands the text box vertically to fit the data in the field when the form or report is printed.

    CanShrink reduces the text box vertically if there is no data in the field when the form or report is printed.

    Tell me if that gets rid of the blank spaces.
    Last edited by Big Booger; October 4th, 2003 at 03:36 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •