text box display

[loki]

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.

 

[Jack Cowley]

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