strike through font

anyone out there know how to make a control's font type
strike through? I have a yes/no field that I'm hoping to
use to set the font of another control depending on a
returned value of -1 or 0. Thanks.

I'm pretty sure Access does not support strikethrough.


Rick B

"mj" wrote in message
...
anyone out there know how to make a control's font type
strike through? I have a yes/no field that I'm hoping to
use to set the font of another control depending on a
returned value of -1 or 0. Thanks.

Depending on your exact requirements, you might be able to use the Line
method of the report. This would require code in the On Format event of the
section of the report containing the text you want to strike through.

--
Duane Hookom
MS Access MVP
--

"mj" wrote in message
...
anyone out there know how to make a control's font type
strike through? I have a yes/no field that I'm hoping to
use to set the font of another control depending on a
returned value of -1 or 0. Thanks.

"mj" wrote in message
...
anyone out there know how to make a control's font type
strike through? I have a yes/no field that I'm hoping to
use to set the font of another control depending on a
returned value of -1 or 0. Thanks.

Access will not _convert_ some font to "strikethrough", but if a
strikethrough font is installed on the machine, you can set the FontName
property of the Control to that font and make _all_ the text in the TextBox
(or other Control) strikethrough. You can't have multiple fonts in a regular
Text Box; you'd need an ActiveX control for RichText to do that (MVP Stephen
Lebans has a free one -- http://www.lebans.com).

Larry Linson
Microsoft Access MVP

I thought you or Fred posted another solution for this issue before
Duane. Using the Line Tool create a Line control that you place directly
over the TextBox. Using the Format event of the relevant Section, set
the Line control's Visible prop as desired.

Me.NameOfLineCOntrol.Visible = THeNameOfTheBooleanControl.Value
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Duane Hookom" wrote in message
...
Depending on your exact requirements, you might be able to use the
Line
method of the report. This would require code in the On Format event
of the
section of the report containing the text you want to strike through.

--
Duane Hookom
MS Access MVP
--

"mj" wrote in message
...
anyone out there know how to make a control's font type
strike through? I have a yes/no field that I'm hoping to
use to set the font of another control depending on a
returned value of -1 or 0. Thanks.