Displaying the Lesson Type field value in a bold,blue text when the value iss "Voice" and in normal black text for all other values. I keep getting running time error '424': object require. Please i need help

please

I'm assuming this is on a form - if so, it would be better to place this in the forms section next time rather than SQL Server. With the error you're getting, it would help if you showed the VBA code you're using, and what the control name is on your form. Right now, I'm assuming that you're referencing a control that doesn't exist, but you may have looked into that already.

Also, have you looked into using Conditional Formatting at all? If you're only changing the text format based on the value being "Voice" than this may be the better way to go.