detect if scrollbar is needed

  • Thread starter Thread starter Angi
  • Start date Start date
A

Angi

I have a Notes subform on my main form. I hate scrollbars so I have
them to set to neither, but if the whole note is not seen, I want to
add a clickable text box to say View and then show the whole note (open
form). I know I can count the characters and if more than that, then
show it, but is there an easier way to detect whether or not the
scrollbar should be there? I promise not too many more questions (at
least for this massive form!!).

TIA!
Angi
 
Angi said:
I have a Notes subform on my main form. I hate scrollbars so I have
them to set to neither, but if the whole note is not seen, I want to
add a clickable text box to say View and then show the whole note (open
form). I know I can count the characters and if more than that, then
show it, but is there an easier way to detect whether or not the
scrollbar should be there? I promise not too many more questions (at
least for this massive form!!).
Click to expand...


While counting the characters (using the Len function) is
far and away the easiest easiest way, it is not particlarly
precise (even if you're using a fixed width font).

You can determine this accurately using the TextHeightWidth
function at www.lebans.com

However, are you aware that there is the buit-in Zoom Box
that users can invoke by hitting Shift+F2?
 
Back
Top