Special Ansi Character on report: Section Symbol

[RNUSZ@OKDPS]

I need to be able to print the Ansi Character set symbol for "Section Symbol"
on an Access report. It is code Ansi Code value 167. It looks like the
capital S with another Capital S struck over the first character, but
slightly raised, very similar to a large character 8 with parts of the
character 8 missing on the lower left of the 8 and the upper right of the 8.

Does anyone have any experience in printing special Ansi Characaters via
Microsoft Access reports. I need to be able to utilize an unbound text box
field, with can grow, can shrink attributes, but be able to format the
character in this field, such as:
say this text below was in an unbound text field:

=" It is hereby ordered, based upon the evidence received at the above
hearing, that the license and registration(s) of " & [LIC_FIRST_NME] & " " &
[LIC_LAST_NME] & " , are hearby suspended immediately for operating or
permitting the operation of a motor vehicle without insurance or security
pursuant to 47 O.S. $7-601".

I need to be able to use this special coded S value in place of the $
character in the above unbound text field (just left of 7-601) .

Has anyone ever performed this type of output....

Thanks,

 

[Duane Hookom]

Your font must support the character. I just did a test with a text box and
held down the [Alt] key when entering 0167. This correctly produced the §
character. The font I used was Arial.

 

[RNUSZ@OKDPS]

Thanks Duane for the reply. Do you think that there would be a way to code
this in VB or maybe in a =Format(field),alt/0167' format statement by code on
a report?

Thanks,

Robert

Your font must support the character. I just did a test with a text box and
held down the [Alt] key when entering 0167. This correctly produced the §
character. The font I used was Arial.

--
Duane Hookom
MS Access MVP
--

I need to be able to print the Ansi Character set symbol for "Section
Symbol"
on an Access report. It is code Ansi Code value 167. It looks like the
capital S with another Capital S struck over the first character, but
slightly raised, very similar to a large character 8 with parts of the
character 8 missing on the lower left of the 8 and the upper right of the
8.

Does anyone have any experience in printing special Ansi Characaters via
Microsoft Access reports. I need to be able to utilize an unbound text
box
field, with can grow, can shrink attributes, but be able to format the
character in this field, such as:
say this text below was in an unbound text field:

=" It is hereby ordered, based upon the evidence received at the above
hearing, that the license and registration(s) of " & [LIC_FIRST_NME] & " "
&
[LIC_LAST_NME] & " , are hearby suspended immediately for operating or
permitting the operation of a motor vehicle without insurance or security
pursuant to 47 O.S. $7-601".

I need to be able to use this special coded S value in place of the $
character in the above unbound text field (just left of 7-601) .

Has anyone ever performed this type of output....

Thanks,

 

[Duane Hookom]

I don't understand. I thought your character was imbedded in the quoted
string in the control source. Is there a reason you don't enter the
character as I suggested?

--
Duane Hookom
MS Access MVP

Thanks Duane for the reply. Do you think that there would be a way to
code
this in VB or maybe in a =Format(field),alt/0167' format statement by code
on
a report?

Thanks,

Robert

Your font must support the character. I just did a test with a text box
and
held down the [Alt] key when entering 0167. This correctly produced the §
character. The font I used was Arial.

--
Duane Hookom
MS Access MVP
--

I need to be able to print the Ansi Character set symbol for "Section
Symbol"
on an Access report. It is code Ansi Code value 167. It looks like
the
capital S with another Capital S struck over the first character, but
slightly raised, very similar to a large character 8 with parts of the
character 8 missing on the lower left of the 8 and the upper right of
the
8.

Does anyone have any experience in printing special Ansi Characaters
via
Microsoft Access reports. I need to be able to utilize an unbound text
box
field, with can grow, can shrink attributes, but be able to format the
character in this field, such as:
say this text below was in an unbound text field:

=" It is hereby ordered, based upon the evidence received at the
above
hearing, that the license and registration(s) of " & [LIC_FIRST_NME] &
" "
&
[LIC_LAST_NME] & " , are hearby suspended immediately for operating or
permitting the operation of a motor vehicle without insurance or
security
pursuant to 47 O.S. $7-601".

I need to be able to use this special coded S value in place of the $
character in the above unbound text field (just left of 7-601) .

Has anyone ever performed this type of output....

Thanks,

 

[RNUSZ@OKDPS]

Duane,
Thanks for the help. At the time that I read your first response, I was at
home and unable to test the resolution, and had the secondary question as to
if it might possibly need to be controlled via Visual Basic Code. (which it
does not). Your original resolution works wonders..... thanks for the
support. I was able to include it today in the report and it works great.

To those whom wish to use special chararcter sets or symbols in their
Microsoft Access reports and possibly even in their forms layouts... you
might try the following.

My resolution (with Mr. Duane Hookom's assistance, thank you very much!) is
this.

I utiliized an unbound text box on the report and coded the formal text as:

=" It is hereby ordered, based upon evidence received at the above
hearing, that the license and registration(s) of " & [LIC_FIRST_NME]+" " &
[LIC_MIDDLE_NME] & [LIC_LAST_NME]+" " & [LIC_SUBT_TXT] & ", is suspended
immediately for operating or permitting the operation of a motor vehicle
without insurance or security persuant to 47 O.S. §7-601. Said suspension
shall continue until proof of current insurance in your name is furnished to
this Department which complies with the requirements of 47 O.S. §7-601, along
with a $100.00 resinstatement fee in the form of a cashier's check or money
order made payable to the Department of Safety."

The special character is called a "Section Symbol" and it is created by
pressing and holding down the ALT key, then pressing (in sequence) 0167.
This produces the § symbol in the report without any errors. I hope this
helps others to understand that if you can identify the ANSI Code value for
special characters, they can be used in Microsoft Access reports easily.

My thanks and gratitude to Mr. Duane Hookom and the other supporters of this
web site. I've learned a lot, and I'm sure I will continue to learn more in
the future.

I don't understand. I thought your character was imbedded in the quoted
string in the control source. Is there a reason you don't enter the
character as I suggested?

--
Duane Hookom
MS Access MVP

Thanks Duane for the reply. Do you think that there would be a way to
code
this in VB or maybe in a =Format(field),alt/0167' format statement by code
on
a report?

Thanks,

Robert

Your font must support the character. I just did a test with a text box
and
held down the [Alt] key when entering 0167. This correctly produced the §
character. The font I used was Arial.

--
Duane Hookom
MS Access MVP
--

I need to be able to print the Ansi Character set symbol for "Section
Symbol"
on an Access report. It is code Ansi Code value 167. It looks like
the
capital S with another Capital S struck over the first character, but
slightly raised, very similar to a large character 8 with parts of the
character 8 missing on the lower left of the 8 and the upper right of
the
8.

Does anyone have any experience in printing special Ansi Characaters
via
Microsoft Access reports. I need to be able to utilize an unbound text
box
field, with can grow, can shrink attributes, but be able to format the
character in this field, such as:
say this text below was in an unbound text field:

=" It is hereby ordered, based upon the evidence received at the
above
hearing, that the license and registration(s) of " & [LIC_FIRST_NME] &
" "
&
[LIC_LAST_NME] & " , are hearby suspended immediately for operating or
permitting the operation of a motor vehicle without insurance or
security
pursuant to 47 O.S. $7-601".

I need to be able to use this special coded S value in place of the $
character in the above unbound text field (just left of 7-601) .

Has anyone ever performed this type of output....

Thanks,