I'm new to visual basic and am in need of help. In Microsoft Access I need to create a procedure with visual basic to display the LessonType field value in bold, blue text when the value is "Voice" and in normal, black text for all other values. I don't have any idea how to do this, could someone help me out please?

I figured it out, I had to write the code in the "On Current" property and this is the code that I used just in case anyone else ever has the same problem.

Option Compare Database Private Sub Form_Current()     'Display the LessonType field value in bold,     'blue text when the value is "Voice"     If [LessonType] = "Voice" Then             [LessonType] = "Voice"             [LessonType].FontBold = True             [LessonType].ForeColor = RGB(0, 0, 255)             Else             [LessonType].FontBold = False             [LessonType].ForeColor = RGB(0, 0, 0)     End If End Sub

[Edited by Sofa_King on 18-10-2009 at 10:09 PM GMT]