Increase line size in labelbox

[Pradeepg]

Hi Experts,

I want to display a text in Indian local language "Kannada". I face issue in displaying full text within labelbox line. Below snap display my issue.

Note:I have label box with size having capability to display multiple line. Though I increase the font it's not helping. Also tried to align text even that is not helping.

I need to something which happens in excel cell, like text needs to be middle and center. You could notice that last letter bottom not displaying in full

Capture.JPGCapture1.JPGCapture2.JPG

Please help in this regards at the earliest.

Pradeep

[patel45]

no jpg please but xlsm file

[Pradeepg]

tesHi,

I have uploaded same issue in excel with snap and userform

[:) Sixthsense :)]

Even I tried the below code but the bottom line of last character is getting affected

Please Login or Register  to view this content.

[patel45]

xlsm file = excel file for testing, not images on xls sheet

[:) Sixthsense :)]

@ patel45,

OP added a sample file in Post #3, please have a look. Unable to fix it from my end too

[Pradeepg]

@patel

To make clear on issue I have added the snap by explaining the concern and also added the userform and test data. Please have look at #3.

Could help me in fixing the issue will be great.

Thanks
Pradeep

[Andy Pope]

I don't think the label control can handle the character as it is not adjusting the line height.

As a work around use a textbox and format that to appear more like a label.

[Pradeepg]

Changed to text as per your suggestion Andy. It works and gives result as need if the text is got single line.. But same issue persist when I have multiple line in textbox.
Could you suggest anything for it?

[Andy Pope]

Does not look like the controls will handle the extra line drop. So using an image or multiple controls appears to be the only option but I don't know whether that will work for your problem.