How can I get a text box on my form to automatically display "Enhancement" but I want to just store "E" in the table that the text boxes control source maps to. I do have a record desription table that has two columns, record type = E and record description = Enhancements, if that is any help.

In the On Current event of the form put code similar to this and put an unbound text box on the form:

If Me.FieldName = "E" then
Me.UnboundFieldName = "Enhancement"
End if

Use a combobox to display the field. Choose the option that hides the key. Enhancement will show in the combobox and E will be stored in the table.