I have several textbox control on a userform. Some are on the form and others
are on a multipage control. They are all set to align text to the left.

When the number of char exeed the width of the textbox (text too long to fit
in the textbox), the alignment become now to the right ! Even when the
userform loads for the first time.

Further more when I put focus on the multipage (click on a textbox on the
multipage) every textbox that have text too long to fit in the textbox change
automatically it's align property to the right.

Text is store on a sheet and is push back on the controls in the
UserForm_Initialize event like so: txt_name.Value = Cells(3, 2)

Anybody have seen this behavior or am I missing a property ??

Merci !
Jean-Francois Grenier.

You can align the text in a textbox or combobox through the properties:

TextAlignLeft
TextAlignCentre or
TextAlignRight

Change to suit

Corey...

"Grenier" <(E-Mail Removed)> wrote in message
news:7A6B5911-0627-41F7-8330-(E-Mail Removed)...
>I have several textbox control on a userform. Some are on the form and
>others
> are on a multipage control. They are all set to align text to the left.
>
> When the number of char exeed the width of the textbox (text too long to
> fit
> in the textbox), the alignment become now to the right ! Even when the
> userform loads for the first time.
>
> Further more when I put focus on the multipage (click on a textbox on the
> multipage) every textbox that have text too long to fit in the textbox
> change
> automatically it's align property to the right.
>
> Text is store on a sheet and is push back on the controls in the
> UserForm_Initialize event like so: txt_name.Value = Cells(3, 2)
>
> Anybody have seen this behavior or am I missing a property ??
>
> Merci !
> Jean-Francois Grenier.

You need to reset the txt_name.SelStart property to 0.

NickHK

"Grenier" <(E-Mail Removed)> wrote in message
news:7A6B5911-0627-41F7-8330-(E-Mail Removed)...
> I have several textbox control on a userform. Some are on the form and
others
> are on a multipage control. They are all set to align text to the left.
>
> When the number of char exeed the width of the textbox (text too long to
fit
> in the textbox), the alignment become now to the right ! Even when the
> userform loads for the first time.
>
> Further more when I put focus on the multipage (click on a textbox on the
> multipage) every textbox that have text too long to fit in the textbox
change
> automatically it's align property to the right.
>
> Text is store on a sheet and is push back on the controls in the
> UserForm_Initialize event like so: txt_name.Value = Cells(3, 2)
>
> Anybody have seen this behavior or am I missing a property ??
>
> Merci !
> Jean-Francois Grenier.