Itallicising from VBA

[Mac]

Hi Everyone,

A hopefully straightforward question, I have a simple VBA public
function (see below) that calls part of a field value so that I can use
it in reports and so forth without having to constantly use the
function. Is there a way for me to pre-format the result so that when
it appears in a report or on a form it's in itallics? Apologies if this
has already been covered somewhere and I've not seen it.

TIA

Mac

Public Function SystemName() As String
SystemName = Mid(DLookup("Setting", "SystemOptions",
"OptionID='SystemName'"), 1, InStr(DLookup("Setting", "SystemOptions",
"OptionID='SystemName'"), ",") - 1)
End Function

 

[Douglas J. Steele]

The only way you can have part of the text appear italicized, and the rest
not, is to use an RTF control. Stephen Lebans has a free one available at
http://www.lebans.com/richtext.htm

 

[Mac]

Dear Doug,

Many thanks, I'll give the RTF option a go and see if that can be
worked into the existing reports.

Regards

Mac