If you are using Access2000 or above, you can use conditional formating. The
condition would be based on the selection in your listbox and you would change
the backcolor of the field in the particular column you want to highlight.
To invoke conditional formating, open your form in design view, select the field
then click on Format - Conditional Formating.
