Consulting

Page 1 of 2 1 2 LastLast
Results 1 to 20 of 31

Thread: Solved: Extra Unwanted Page at End of Document

  1. #1
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location

    Solved: Extra Unwanted Page at End of Document

    Okay, annoying issue here. Not VBA related. I have an extra page on one of my forms (creation in-progress), it's uploaded. Can somebody take a look and tell me how to get rid of that extra page at the end? I'd really, really appreciate it. It's quite annoying.

  2. #2
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Hit Ctrl+End.
    Hit Shift+Right arrow.
    Type a 1 into the Font size box (don't dropdown) and hit Enter.
    Voila!
    ~Anne Troy

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Okay, you're good. I knew that. But what happened with that? I mean, what did I do to not be able to just select the end (Ctrl + End) and press backspace?

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Sometimes that happens to me too. There isn't enough room to go to the end of the table, but the table is also too big and a second page is added.

  5. #5
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Ah, gotcha. A table thing.

    Still not experienced enough with Word to feel comfortable. Just don't spend enough time with it.

    Thanks much guys!!

  6. #6
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I always go for the hidden font on the trailing para mark 'cos one day that little space will still go onto the next page!

  7. #7
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Quote Originally Posted by mdmackillop
    I always go for the hidden font on the trailing para mark 'cos one day that little space will still go onto the next page!
    Huh?

  8. #8
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Select the paragraph mark, Format/Font/Hidden and it goes away completely when you print or preview with format marks hidden.

  9. #9
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Okay Malcolm. I don't do Word; period. Take baby steps with me. What paragraph mark? (Found the Format --> Font --> Hidden)

  10. #10
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Hi Zack,
    It's the P thing that goes onto the next page. There's alway one after a table. Hidden here on your example.
    Malcolm

  11. #11
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Okay, so it follows a table. Any/every table? What does it look like? How do I know it is there? Is it always hidden? Can I unhide?

  12. #12
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    • Tools

    • Options

    • View

    • Paragraph marks

  13. #13
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    See attached picture.

  14. #14
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Whoohoo! I see it! Word 101 !!

    Thanks fellas!

  15. #15
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I knew there was a "proper" name for it, Just couldn't remember it.

    From Wikipedia, the free encyclopedia.



    The pilcrow (?) is what most people commonly refer to as the paragraph symbol. This non-alphabetic symbol varies from typeface to typeface, but the form shown here is probably fairly typical.

  16. #16
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    What? I always called it the backwards pee.
    ~Anne Troy

  17. #17
    VBAX Tutor TheAntiGates's Avatar
    Joined
    Feb 2005
    Location
    Tejas
    Posts
    263
    Location
    When I'm really squeezing to keep a page from continuing, and don't want to sacrifice text font size or margins or use other methods of conventional warfare, I will go to every linefeed between paragraphs, and incrementally lower the font on them one-by-one until paydirt. By this I mean as described above - with shift-left-arrow.

    Hmmm, if this isn't born to be solved with VBA ... the key would be how to find the paragraph marks (or hard line feeds?).
    I just found a cool semi-advanced VBA page - dictionary, queue, etc. http://analystcave.com/excel-vba-dic...ta-structures/

  18. #18
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    LOL, AntiGates. If THAT's the case, you just go to Print Preview and hit the "fit to page" button.
    ~Anne Troy

  19. #19
    VBAX Tutor TheAntiGates's Avatar
    Joined
    Feb 2005
    Location
    Tejas
    Posts
    263
    Location
    True, though doesn't the text matter font sometimes drop then?
    I just found a cool semi-advanced VBA page - dictionary, queue, etc. http://analystcave.com/excel-vba-dic...ta-structures/

  20. #20
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Not sure. I never use it. I always do what you do.
    ~Anne Troy

Posting Permissions

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