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)
[LessonType].FontBold = False
[LessonType].ForeColor = RGB(0, 0, 0)
[Edited by Sofa_King on 18-10-2009 at 10:09 PM GMT]