How to insert whitespace (square) in checkbox caption

[dave8]

Is there a way to insert a square box (used as whitespace) in a checkbox caption?

 

[Andrew Poulsom]

Is there such a character in the font you are using? The caption can only have one font.

 

[dave8]

Is there such a character in the font you are using? The caption can only have one font.

There is no such character in the font, but I need to somehow use this character for formatting purpose.

I am entering text on a checkbox caption that takes multiple line:

1. For example, here is a line of text I am typing in a checkbox caption property
that I want to format and look like this:

1. I want to create some whitespace before the word, "that" so the line
will look like this.

Is there a way to do this? I tried manually entering spaces but that doesn't seem to work.

 

[Andrew Poulsom]

Is the WordWrap property set to True?

 

[dave8]

Is the WordWrap property set to True?

Yes, wordwrap is set to true. But, I want to correct my previous example:

I am entering text on a checkbox caption that takes multiple line:

1. For example, here is a line of text I am typing in a checkbox caption property
that I want to format and look like this:

1. I want to create some whitespace before the word, "that" so the line
will look like this.

In the second example above, I want to indent the second line.

Is there a way to do this? I tried manually entering spaces but that doesn't seem to work.

 

[Andrew Poulsom]

Sorry, I don't think it's possible. Multiple spaces are ignored if they appear at a word wrap.

 

[pgc01]

Hi

I used spaces to indent the second line in the checkbox caption and it worked for me:

CheckBox1.Caption = "Hi" & vbLf & " there!"

I forced the line break with a Line Feed.

 

[Andrew Poulsom]

Excellent Pedro. I hadn't thought of VBA.