View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_21_] Stuart[_21_] is offline
external usenet poster
 
Posts: 154
Default Userform Textbox - fundamental flaw

Perhaps not as simple, as simple me, first thought.

The textbox's height property is set to 419.25 (which I believe is a value
in points) and the width to 102.
The Font is set to Times New Roman, FontSize to 12 and Bold.

Help for MaxLength gives one option:
MaxLength Property (Forms)
which says I can set the maximum number of characters in the
textbox.................

I have absolutely no idea how I can calculate that.

Help please.

Regards.




Tom Ogilvy" wrote in message
...
How about using the maxlength property.

--
Regards,
Tom Ogilvy


"Stuart" wrote in message
...
Oops, just discovered a flaw (probably one of many to come).
The form is designed to represent an A4 page in portrait mode, where
basically the bottom two thirds are occupied by one large textbox.

If I go into this textbox and keep pressing Enter, I can get to the very
bottom of the textbox and I can enter text.

But if I then press Enter the textbox scrolls up the form,
giving the user the impression that the textbox is expanding to meet the
user's needs.

Can I stop this, please?

Regards.