View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Userform Textbox - fundamental flaw

Stuart,
Using a fixed width font will make this easier.
If you must use a proportional width font, fill the text box with "W" and
use that number of caharacters.

NickHK

"Stuart" wrote in message
...
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.