Using Character maps to replace the number 1 in a text box??

[neemi]

I have a report based on a crosstab query. The report outputs basically student information with column headings of 1 to 20. (1 to 20 representing variuos courses)

At the moment if the student is on one of the courses a number 1 will appear in the corresponding text box. I don't want to use check boxes in my reportas it doesn't look very good.

I was wondering how I could have a character map appear in place of the number ones, on my report if a student is on the course.

I was wanting something like a happy face or something if possible.

Any help appreciated.

Any other suggestions also appreciated.

 

[DrSimon]

What a lovely idea. I just tried something and it seemed to work. I pasted a smiley from Word into a report detail and named the object 'Face'. I then insted the following code in the Detail_Format Sub:
If [ID] = 1 Then
Face.Visible = True
Else
Face.Visible = False
End If

And it seemed to work!

Simon Rouse

 

[67peshawar294]

neemi,
you could also, if you have wingdings font, put in the textbox;
=If [field]=1,"J",[field]
"J" is the char for a smily face in the wingdings font.
jim

 

[neemi]

Both ideas great.. only tried xaf294's idea. Cheers. One last thing... it appears that i cannot really use the smiley face and need to use a big tick instead...

Do you know if there is an equivelant for a tick as with the smiley face?

Cheers

Neemi

 

[DrSimon]

Good idea Jim
Neemi - you'll need to replace "J" with chr(252) to get your tick. If you need to change it, the simplest way is to look at the symbols table in Word. When you pick a character in a font you should be able to see the character code displayed: Tick is 252

 

[67peshawar294]

neemi,
There is also a tick with a box around it chr(254).
Check out your; start,programs,accessories, character map.
Select the wingdings font, or any other. Watch the bottom right when you click on a character. The keystroke will be displayed.
jim