In VBA for access 2000, it was really easy to prevent someone from entering a value that was not in the list. In the combobox's properties, you just change the "LIMIT TO LIST" property to True ...

For instance, can you conditionally format the selected value in a combo box control? The answer is yes, but you won’t use conditional formatting; you’ll use a VBA procedure.