Attach a TM Symbol to text

[dontay]

Hi,
How can I attach a TM Symbol to text in an Access Report?
I can format a text box to use the Symbol font but I can't put text with it.

I'm stuck on this one.

 

[speke]

On the format event of the section with your text box add a variation of the following code:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)

Me.MyTextBox = Me.MyTextBox & Chr(153)

End Sub

Where MyTextBox is the name of your text box.

You can add other symbols too, if you use the following code, it will give you a list of the relevant chr number to use:

Sub test()

Dim x As Integer

For x = 1 To 255
Debug.Print x & " " & Chr(x)
Next x

End Sub

 

[dontay]

Thanks Speke,
I put the code into the report but I get this error:
"You can't assign a value to this obect"

I looked up CHR in help and it said that that it behaves different depending on what version of access I am using.
I'm using Access 2000.
I think we're on the right track.
But I'm stuck again.