Hi,
What kind of formatting options do you need? You may want to look at the combobox control. Virtually all of the properties can be controlled conditionally.
Here is a simple example:
if [fldCustomerState] = "CA" then
cmbCountyList.backcolor = vbRed
cmbCountyList.FontBold = True
cmbCountyList.forecolor = vbBlack
end if
HTH,
Randy Smith
California Teachers Association