Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Form content availability (Word 2003 onwards)

    Well, that's not quite the word I want but I can't think what is ... anyway, what I want is the property of a textbox on a userform that enables it to acquire scrollbars and allow more content than will show within the basic area available? I've got Scrollbars set to 2 - Vertical and every other property I can think of that might affect it I've set to the most likely setting, but it still just truncates long entries at the bottom of the box (or at least, it might not do, but since it doesn't acquire the scrollbars needed to check what's below the bottom of the box I can't tell!).

    Many thanks!
    Beryl M


  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Form content availability (Word 2003 onwards)

    Thanks, Hans, but I don't have that property? The properties I have for my textbox are in the screenshot below - perhaps you can spot where I'm going wrong!
    Attached Images Attached Images
    Beryl M


  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form content availability (Word 2003 onwards)

    I'm sorry, I read your question carelessly and interpreted it incorrectly. Forget my previous reply.

    I see that you have already set MultiLine to True, so I don't understand why the scrollbar doesn't work. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    You may also want to set EnterKeyBehavior to True - this enables the user to start a new line by pressing Enter.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form content availability (Word 2003 onwards)

    You could also try setting the IntegralHeight property to True.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Form content availability (Word 2003 onwards)

    I don't think that changed anything (although I couldn't swear to it!!) but I've found out what it was - you have to click into the box before the scrollbars will appear. Since I'm using this for reference only (ie it's just displaying the contents of the Autotext entry in the box, not being edited) that's not quite what I wanted, but at least I know how to get the scrollbars now!

    Thanks Hans!
    Beryl M


  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form content availability (Word 2003 onwards)

    You have to set the ScrollHeight property of the userform to the height of the area that is available. It is measured in points where 72 points = 1 inch.
    For example, if the bottommost control has Top = 180 and Height = 24 you could set ScrollHeight to 210 (a bit more than 180+24),.

Posting Permissions

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