Align Text Box Verticaly Center (1 Viewer)

JithuAccess

Member
Local time
Today, 16:49
Joined
Mar 3, 2020
Messages
35
Hello Guys,

How could I align the Text Box Aligned Vertically Centered in the Text Box of a Report?

This is what I am getting now:


1583945219391.png

I want this to be aligned like this:

1583945343235.png

Thanks
 

CJ_London

Super Moderator
Staff member
Local time
Today, 23:49
Joined
Feb 19, 2013
Messages
12,128
not sure what you are demonstrating shows the issue you are having - the only difference I can see is that the bottom example has a narrower control than the top example - so why don't you just adjust the width of the control?
 

theDBguy

I’m here to help
Local time
Today, 15:49
Joined
Oct 29, 2018
Messages
10,765
Hi. Unfortunately, I don't think Access Textboxes have that feature like you would see in Word or Excel. Sorry...
 

JithuAccess

Member
Local time
Today, 16:49
Joined
Mar 3, 2020
Messages
35
not sure what you are demonstrating shows the issue you are having - the only difference I can see is that the bottom example has a narrower control than the top example - so why don't you just adjust the width of the control?
Thanks a lot for your Reply.

Apologies if I was not clear.

1583946147257.png

and I want to Vertically Center Align my Text Box.

Thanks
 

theDBguy

I’m here to help
Local time
Today, 15:49
Joined
Oct 29, 2018
Messages
10,765
Thanks a lot For your reply.
I think, maybe, the closest thing you could do is use a matching font size to the size of your textbox to approximate being aligned vertically. I hope somebody else has a better idea though. Good luck!
 

JithuAccess

Member
Local time
Today, 16:49
Joined
Mar 3, 2020
Messages
35
I guess I did it :)

1583946477598.png

I just adjusted the Top Margin Property of the Text Box.

1583946694356.png

Thanks a lot
 

CJ_London

Super Moderator
Staff member
Local time
Today, 23:49
Joined
Feb 19, 2013
Messages
12,128
ah - obvious now:). If a manual setting of top margin meets your needs then that is OK. If you need a more automated approach it can be done with vba. Would involve determining the control height in twips (easy), less the font height in twips (not so easy) and dividing by 2 - the result would be the top margin in twips, which is what access actually uses (0.25cm=142 twips)
 

JithuAccess

Member
Local time
Today, 16:49
Joined
Mar 3, 2020
Messages
35
ah - obvious now:). If a manual setting of top margin meets your needs then that is OK. If you need a more automated approach it can be done with vba. Would involve determining the control height in twips (easy), less the font height in twips (not so easy) and dividing by 2 - the result would be the top margin in twips, which is what access actually uses (0.25cm=142 twips)
Thanks a lot
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom