Re: Syntax for textalign property

[alicejwz]

Re: Syntax for textalign property

Hi,

I like to know the syntax to set the textalign property to Right for a textbox. by setting the property in Access works when I type but the field(s) is populated thru recordsource it shifted to the left regardless the setting in Access. Seems to me I will need to set it VBA code. What would be the syntax to set the control to align to the Right? Thanks!

 

[trucktime]

Align

Try this:

Me.myField.TextAlign = 3

 

[alicejwz]

Re: Syntax for textalign property

Thanks trucktime!
Your code works great.
I think my problem was that there were blank spaces in the field that cause the value aligned to left. Thanks for your help!

 

[trucktime]

Align

You're welcome.