Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format a textbox in VBA

Status
Not open for further replies.

Softop

Programmer
Sep 26, 2003
18
GB
I need to format a textbox on a report to italics depending on the result of another field. i.e.

Code:
    If Me.txtVerse = "C" Then
        Me.txtLine   'format to italics   ???????
    Else
        Me.txtLine   'format to normal    ???????
    End If
Any idea how to do this?

 
Don't worry - solved it myself!
Code:
    If Me.txtVerse = "C" Then
        Me.txtLine.FontItalic = True
    Else
        Me.txtLine.FontItalic = False
    End If

Thanks for looking anyway!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top