Center Text Vertically - Microsoft Access Forum


	Back to Access Forum Comments List

Center Text Vertically

William Farrar

5 years ago

I noticed that if you create a button in a form, the text is automatically centered top to bottom and left to right regardless of the font, size, attributes, etc.; however, when you create a text box and/or label, the text is only centered left to right under the same conditions as the button.

I've compared the various setting between the two and I'm unable to locate the setting that is changing in the properties even if I just change the size of the button. None of the Margins or Padding settings are changing that I can see.

How do I get the text inside a textbox/label to center top to bottom?

	Richard Rost @Reply 5 years ago
Hi William. Unfortunately there's no "align top to bottom" or "center vertically" option available for text boxes or labels in Access. Now you CAN manipulate the top margin and try to calculate the size needed based on the amount of text in a textbox. A member recently asked about this recently, and I'll be making a TechHelp video about it soon.

	Adam Schwanz @Reply 5 years ago
You could always use a button with no caption and put a label over it :P. It's a ton of extra work but if you needed it that badly. Might need to change the on click of the label to open the form the button does as well and bring it to front.

	Juan C Rivera @Reply 5 years ago

	Juan C Rivera @Reply 5 years ago

	Juan C Rivera @Reply 5 years ago
This is how I did it some time ago, I love pictures in my button but if you dont use pictures it work the same picture caption to general and add spacess. See if that helps.

	Richard Rost @Reply 5 years ago
Yeah, but if you want a text box to dynamically keep text centered horizontally and vertically, it's gonna need some VBA lovin'. Don't worry guys. I got this. Tomorrow's TechHelp.

	Richard Rost @Reply 5 years ago

	Richard Rost @Reply 5 years ago

	Juan C Rivera @Reply 5 years ago
Richard you are the bomb......VBA is the S.. almost said it...LOL

	Richard Rost @Reply 5 years ago
Here you go, boys: Center Vertically

	Scott Axton @Reply 5 years ago
Don't ever say, "Richard I bet you can't...xxx. 'Cause Richard will reply, "Here, hold my beer and watch!" You do love a challenge.

	Richard Rost @Reply 5 years ago
That's one of the reasons I love doing the TechHelp videos. I enjoy a good challenge... something I haven't done before. Plus they're short, informal, require a lot less planning, and I have FUN with them! :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen