How to Display Checkbox on Report
A textbox with Wingdings font type can be used to display a checkbox on a report which is checked based on a value in a dataset. Wingdings are a series of fonts which render letters as a variety of symbols.
Select a text box:
Change a font family to Windings:
In a Value type the following expression:
- In my case the Fields!active.Value returns True or False, but it can be any type of value
Run the report to see check boxes:
When used chr(0238), a falling arrow is displayed instead:
=iif(Fields!active.Value,chr(0238),“o”)
List of possible characters in the Wingdings font are displayed below:
| Wingdings | |||
| Character |
Dec |
Hex |
PS Name |
| ‘‘ |
32 |
0x20 |
space |
| |
33 |
0x21 |
pencil |
| |
34 |
0x22 |
scissors |
| |
35 |
0x23 |
scissorscutting |
| |
0x24 |
readingglasses | |
| |
37 |
0x25 |
bell |
| |
38 |
0x26 |
book |
| |
39 |
0x27 |
candle |
| |
40 |
0x28 |
telephonesolid |
| |
41 |
0x29 |
telhandsetcirc |
| |
42 |
0x2A |
envelopeback |
| |
43 |
0x2B |
envelopefront |
| |
44 |
0x2C |
mailboxflagdwn |
| |
45 |
0x2D |
mailboxflagup |
| |
46 |
0x2E |
mailbxopnflgup |
| |
47 |
0x2F |
mailbxopnflgdwn |
| |
48 |
0x30 |
folder |
| |
49 |
0x31 |
folderopen |
| |
50 |
0x32 |
filetalltext1 |
| |
51 |
0x33 |
filetalltext |
| |
52 |
0x34 |
filetalltext3 |
| |
53 |
0x35 |
filecabinet |
| |
54 |
0x36 |
hourglass |
| |
55 |
0x37 |
keyboard |
| |
56 |
0x38 |
mouse2button |
| |
57 |
0x39 |
ballpoint |
| |
58 |
0x3A |
pc |
| |
59 |
0x3B |
harddisk |
| |
60 |
0x3C |
floppy3 |
| |
61 |
0x3D |
floppy5 |
| |
62 |
0x3E |
tapereel |
| |
63 |
0x3F |
handwrite |
| |
64 |
0x40 |
handwriteleft |
| |
65 |
0x41 |
handv |
| |
66 |
0x42 |
handok |
| |
67 |
0x43 |
thumbup |
| |
68 |
0x44 |
thumbdown |
| |
69 |
0x45 |
handptleft |
| |
70 |
0x46 |
handptright |
| |
71 |
0x47 |
handptup |
| |
72 |
0x48 |
handptdown |
| |
73 |
0x49 |
handhalt |
| |
74 |
0x4A |
smileface |
| |
75 |
0x4B |
neutralface |
| |
76 |
0x4C |
frownface |
| |
77 |
0x4D |
bomb |
| |
78 |
0x4E |
skullcrossbones |
| |
79 |
0x4F |
flag |
| |
80 |
0x50 |
pennant |
| |
81 |
0x51 |
airplane |
| |
82 |
0x52 |
sunshine |
| |
83 |
0x53 |
droplet |
| |
84 |
0x54 |
snowflake |
| |
85 |
0x55 |
crossoutline |
| |
86 |
0x56 |
crossshadow |
| |
87 |
0x57 |
crossceltic |
| |
88 |
0x58 |
crossmaltese |
| |
89 |
0x59 |
starofdavid |
| |
90 |
0x5A |
crescentstar |
| |
91 |
0x5B |
yinyang |
| |
92 |
0x5C |
om |
| |
93 |
0x5D |
wheel |
| |
94 |
0x5E |
aries |
| |
95 |
0x5F |
taurus |
| |
96 |
0x60 |
gemini |
| |
97 |
0x61 |
cancer |
| |
98 |
0x62 |
leo |
| |
99 |
0x63 |
virgo |
| |
100 |
0x64 |
libra |
| |
101 |
0x65 |
scorpio |
| |
102 |
0x66 |
saggitarius |
| |
103 |
0x67 |
capricorn |
| |
104 |
0x68 |
aquarius |
| |
105 |
0x69 |
pisces |
| |
106 |
0x6A |
ampersanditlc |
| |
107 |
0x6B |
ampersandit |
| |
108 |
0x6C |
circle6 |
| |
0x6D |
circleshadowdwn | |
| |
110 |
0x6E |
square6 |
| |
111 |
0x6F |
box3 |
| |
112 |
0x70 |
box4 |
| |
113 |
0x71 |
boxshadowdwn |
| |
114 |
0x72 |
boxshadowup |
| |
115 |
0x73 |
lozenge4 |
| |
116 |
0x74 |
lozenge6 |
| |
117 |
0x75 |
rhombus6 |
| |
118 |
0x76 |
xrhombus |
| |
119 |
0x77 |
rhombus4 |
| |
120 |
0x78 |
clear |
| |
121 |
0x79 |
escape |
| |
122 |
0x7A |
command |
| |
123 |
0x7B |
rosette |
| |
124 |
0x7C |
rosettesolid |
| |
125 |
0x7D |
quotedbllftbld |
| |
126 |
0x7E |
quotedblrtbld |
| |
127 |
0x7F |
.notdef |
| |
128 |
0x80 |
zerosans |
| |
129 |
0x81 |
onesans |
| |
130 |
0x82 |
twosans |
| |
131 |
0x83 |
threesans |
| |
132 |
0x84 |
foursans |
| |
133 |
0x85 |
fivesans |
| |
134 |
0x86 |
sixsans |
| |
135 |
0x87 |
sevensans |
| |
136 |
0x88 |
eightsans |
| |
137 |
0x89 |
ninesans |
| |
138 |
0x8A |
tensans |
| |
139 |
0x8B |
zerosansinv |
| |
140 |
0x8C |
onesansinv |
| |
141 |
0x8D |
twosansinv |
| |
142 |
0x8E |
threesansinv |
| |
143 |
0x8F |
foursansinv |
| |
144 |
0x90 |
fivesansinv |
| |
145 |
0x91 |
sixsansinv |
| |
146 |
0x92 |
sevensansinv |
| |
147 |
0x93 |
eightsansinv |
| |
148 |
0x94 |
ninesansinv |
| |
149 |
0x95 |
tensansinv |
| |
150 |
0x96 |
budleafne |
| |
151 |
0x97 |
budleafnw |
| |
152 |
0x98 |
budleafsw |
| |
153 |
0x99 |
budleafse |
| |
154 |
0x9A |
vineleafboldne |
| |
155 |
0x9B |
vineleafboldnw |
| |
156 |
0x9C |
vineleafboldsw |
| |
157 |
0x9D |
vineleafboldse |
| |
158 |
0x9E |
circle2 |
| |
159 |
0x9F |
circle4 |
| |
160 |
0xA0 |
square2 |
| |
161 |
0xA1 |
ring2 |
| |
162 |
0xA2 |
ring4 |
| |
163 |
0xA3 |
ring6 |
| |
164 |
0xA4 |
ringbutton2 |
| |
165 |
0xA5 |
target |
| |
166 |
0xA6 |
circleshadowup |
| |
167 |
0xA7 |
square4 |
| |
168 |
0xA8 |
box2 |
| |
169 |
0xA9 |
tristar2 |
| |
170 |
0xAA |
crosstar2 |
| |
171 |
0xAB |
pentastar2 |
| |
172 |
0xAC |
hexstar2 |
|
173 |
0xAD |
octastar2 | |
| |
174 |
0xAE |
dodecastar3 |
| |
175 |
0xAF |
octastar4 |
| |
176 |
0xB0 |
registersquare |
| |
177 |
0xB1 |
registercircle |
| |
178 |
0xB2 |
cuspopen |
| |
179 |
0xB3 |
cuspopen1 |
| |
180 |
0xB4 |
query |
| |
181 |
0xB5 |
circlestar |
| |
182 |
0xB6 |
starshadow |
| |
183 |
0xB7 |
oneoclock |
| |
184 |
0xB8 |
twooclock |
| |
185 |
0xB9 |
threeoclock |
| |
186 |
0xBA |
fouroclock |
| |
187 |
0xBB |
fiveoclock |
| |
188 |
0xBC |
sixoclock |
| |
189 |
0xBD |
sevenoclock |
| |
190 |
0xBE |
eightoclock |
| |
191 |
0xBF |
nineoclock |
| |
192 |
0xC0 |
tenoclock |
| |
193 |
0xC1 |
elevenoclock |
| |
194 |
0xC2 |
twelveoclock |
| |
195 |
0xC3 |
arrowdwnleft1 |
| |
196 |
0xC4 |
arrowdwnrt1 |
| |
197 |
0xC5 |
arrowupleft1 |
| |
198 |
0xC6 |
arrowuprt1 |
| |
199 |
0xC7 |
arrowleftup1 |
| |
200 |
0xC8 |
arrowrtup1 |
| |
201 |
0xC9 |
arrowleftdwn1 |
| |
202 |
0xCA |
arrowrtdwn1 |
| |
203 |
0xCB |
quiltsquare2 |
| |
204 |
0xCC |
quiltsquare2inv |
| |
205 |
0xCD |
leafccwsw |
| |
206 |
0xCE |
leafccwnw |
| |
207 |
0xCF |
leafccwse |
| |
208 |
0xD0 |
leafccwne |
| |
209 |
0xD1 |
leafnw |
| |
210 |
0xD2 |
leafsw |
| |
211 |
0xD3 |
leafne |
| |
212 |
0xD4 |
leafse |
| |
213 |
0xD5 |
deleteleft |
| |
214 |
0xD6 |
deleteright |
| |
215 |
0xD7 |
head2left |
| |
216 |
0xD8 |
head2right |
| |
217 |
0xD9 |
head2up |
| |
218 |
0xDA |
head2down |
| |
219 |
0xDB |
circleleft |
| |
220 |
0xDC |
circleright |
| |
221 |
0xDD |
circleup |
| |
222 |
0xDE |
circledown |
| |
223 |
0xDF |
barb2left |
| |
224 |
0xE0 |
barb2right |
| |
225 |
0xE1 |
barb2up |
| |
226 |
0xE2 |
barb2down |
| |
227 |
0xE3 |
barb2nw |
| |
228 |
0xE4 |
barb2ne |
| |
229 |
0xE5 |
barb2sw |
| |
230 |
0xE6 |
barb2se |
| |
231 |
0xE7 |
barb4left |
| |
232 |
0xE8 |
barb4right |
| |
233 |
0xE9 |
barb4up |
| |
234 |
0xEA |
barb4down |
| |
235 |
0xEB |
barb4nw |
| |
236 |
0xEC |
barb4ne |
| |
237 |
0xED |
barb4sw |
| |
238 |
0xEE |
barb4se |
| |
239 |
0xEF |
bleft |
| |
240 |
0xF0 |
bright |
| |
241 |
0xF1 |
bup |
| |
242 |
0xF2 |
bdown |
| |
243 |
0xF3 |
bleftright |
| |
244 |
0xF4 |
bupdown |
| |
245 |
0xF5 |
bnw |
| |
246 |
0xF6 |
bne |
| |
247 |
0xF7 |
bsw |
| |
248 |
0xF8 |
bse |
| |
249 |
0xF9 |
bdash1 |
| |
250 |
0xFA |
bdash2 |
| |
251 |
0xFB |
xmarkbld |
| |
252 |
0xFC |
checkbld |
| |
253 |
0xFD |
boxxmarkbld |
| |
254 |
0xFE |
boxcheckbld |
|
|
255 |
0xFF |
windowslogo |
文章转载自:http://kkryczka.wordpress.com/2010/12/09/how-to-display-checkbox-on-report/