Checkmark Box

[Arturo]

I am recreating a Word form in Access 2003. It has to be exactly the same. On
the form there are several checkmarks. They are a standard feature and never
change. They are always displayed. They do not have the box around the
checkmark. Is there a way in Access to display only the checkmark?

Thank you.

 

[Al Campagna]

Arturo,
Instead of a checkmark control, use a regular text control. with no
visible background or border.
When clicked, set the value to "X".
When clicked again, set the value to Null.
If you want... in the background, and hidden, you can code to set a
"real" checkbox field to True or False, accordingly.

Private Sub MyCheck_Click()
If MyCheck = "X" Then
MyCheck = Null
MyRealCheckField = True
ElseIf IsNull(MyCheck) Then
MyCheck = "X"
MyRealCheckField = False
End if
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Allen Browne]

Use a text box with a WingDings character to simulate a check box.

Details:
Format Check boxes on reports
at:
http://allenbrowne.com/ser-52.html

This will also solve the problem that the check boxes (as graphical items)
disappear if you export a report to Word (RTF.)

 

[Golfinray]

Try right clicking on the checkbox, go to format, and set border style to
transparent.

 

[Golfinray]

Right click on the checkbox, go to format, and set the border style to
transparent.

 

[John Spencer]

As far as I know that will not work with a checkbox. You will still see the
border and the background.

Better solution is to use a textbox with
--border set to transparent
--backstyle set to transparent
--Font set to WingDings
--Font Size set to 24 (or whatever size works)
--Control Source set to
=Chr(252)

Chr(252) in WingDings font is a check mark.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Arturo]

This worked great. Thanks. Also, how do I get a list of the Chr functions?

 

[John W. Vinson]

This worked great. Thanks. Also, how do I get a list of the Chr functions?

Windows Start... All Programs... Accessories... System Tools... Character Map.
The location might differ on your machine.

 

[Arturo]

Thanks for your quick reply. What I was trying to get is the numbers, like
Chr(252) is a Checkmark, and Chr(10) is a carriage return. Where are those?

 

[John Spencer]

Look up Ascii in the help. That should lead you to a table of Ascii values
for the lower numbers.

Using the character map you will see a hex code for the selected character at
the bottom of the screen. You can translate that by using this expression.
For instance the check mark in WingDing Font is FC. Add &H to the beginning
of that to tell VB this is a hex value.

You can use the Hex value directly or you can get its value

CHR(&HFC) >>> umlauted lower case u which is the Check Mark in the WingDings fonts
Val(&HFC) >>> 252

This doesn't always work for me, but it usually does.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Al Campagna]

Arturo,
I use a freeware utility called My CharMap, which is available on the
web.
It's an improvement over the CharMap that comes with windows. Bigger
display, and better Ascii value display.
I often use graphic type fonts (WingDing, Dixieland, etc...), so I have
My CharMap "hotkeyed" for Ctrl-Shift-A.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."