Can A Checkbox display and print an "X" 1

[jmueller]

I'm wondering if anyone can help me out on this. I simply would like to have our checkboxes display and print an "X" rather than a "checkmark". Please help if you can and thank you in advance.

Jack.

 

[SkipVought]

Hi,

Not with a CheckBox.

But...

Try this.

Add a TextBox

Insert this code...

Private Sub TextBox1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    With TextBox1
        If .Text = "" Then
            .Text = "X"
        Else
            .Text = ""
        End If
    End With
End Sub

Now click the box ;-)


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[Dreamboat]

What kind of checkbox are you using?

The checkboxes from the Forms toolbar WILL display and print with an X if the checkbox has been selected.

See if you are using Fill-In Forms:

http://www.theofficeexperts.com/word.htm#Fill-inForms

Otherwise, if you're inserting a symbol of a checkbox with a check in it, just insert a different symbol like the checkbox with the X in it. You may need to look for it under a different font.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[jmueller]

Skip, your suggestion works well. Thanks.

Dreamboat, I must be missing something but when I use a checkbox from the forms toolbar, it always shows as a checkmark not an X. If i'm missing something, please let me know because it would be easier to simply add checkboxes rather than going skip's route due to the fact that I have about 70 checkboxes to add.

Thanks to both of you for your help!

Jack.

 

[Dreamboat]

Jack: You need to check out the link to know what's going on. You may want to check it out if you're making forms 'cause it's a really terrific method. It's not too terribly much to read...

Let me know if you have any questions.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[dcompto]

Not a complaint, just comments in passing...

(1) At times, it is very unclear to me which Application a thread is referencing as in this thread.

(2)I know how to use Word's checkbox form field which does produce a checkBOX with an X in it as Dreamboat indicated. I've also used the checkbox control in Access which produces a checkMARK. I didn't realize until reading this thread, and investigating, that PowerPoint also has a checkbox control (about which I am clueless).

Every day I realize... so much to learn... so little time.

Thanks to all! Shared knowledge is a beautiful thing!

 

[Dreamboat]

You're perfectly right, dcompto!
I think we often read a thread and from what we read, we do a wishful thinking kinda thing and assume it's in the area of our expertise. LOL!!

Excel also has a checkbox under Forms and a checkbox under the control toolbox.

What's cool is knowing the difference and when to use one or the other. Controls ought to use VBA to handle the choice. Forms don't use VBA code, which is sometimes not wanted.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[jmueller]

You know, I just realized it would have helped if I had mentioned that I was using Excel! Sorry about that... my first time in the "office" area of tek-tips. Anyways, thanks again to all and as dcompto said, "Shared knowledge is a beautiful thing" and as dreamboat said, "we are all experts" and as Tiny Tim said: "God Bless Us Everyone". Okay okay, i'm getting a little carried away now!