Hi,

Does anyone got the idea that how can I check whether a command button got one line of caption or more than one line?

Wait to get helped.

Thanks,

I am not sure what you mean by this. The button can only have one caption line, but it can be split in two if the button is sized properly. The application will only see one line no matter how many lines it is split into visually, if I understand you.

Perhaps you can check the button height instead.

Why do you need to check this? Maybe there is another way.

HTH


mmcdonal

Well, thank you mmcdonal.

I did the solution using "Instr" function to search for the "vbcrlf" in the caption of button.

Regard,

Hi,
if you caption text is longer than width of Button, then will be split to two lines automatically without any newline symbol (e.g. vbNewLine, or other).
But, if you would like to search exact phrase vbNewLine in caption text, syntax is:

Dim position As Long
position = InStr(1, Button.Caption, vbNewLine, vbBinaryCompare)

If position > 0 Then
'there is more lines in text
End If

Peko

Thanks for that. I didn't know about vbNewLine (I usually use vbCrLf when I need this, but I haven't used it in button text.


mmcdonal

Ya, I get used to "vbCrlf" and it is good to get an easier one with "VbNewLine"

Thank,