Text Font Color based on Tab Selected

[vbaInet]

Ok let's get you two looping:

dim ctl as access.control

for each ctl in me.detail.controls
    msgbox ctl.name
next

See what you can do with that. ctl is a control and it's going to loop through all the controls in the detail section.

First of all try it on a standalone form, not via the navigation pane.