It did that by default so I was wondering if it was needed, here are the two I tried:
This one produced the error in the last message (The expression you entered contains invalid syntax..)
Code:
=Switch(ObscureCode = "001", "Code1",ObscureCode = "002", "Code2",ObscureCode = "003", "Code3",ObscureCode = "004", "Code4")
This one has a warning Invalid Control Property: Control Source --> Cicular Reference
Code:
=Switch([ObscureCode] = "001", "Code1",[ObscureCode] = "002", "Code2",[ObscureCode] = "003", "Code3",[ObscureCode] = "004", "Code4")
Edit: I am putting this in the Control Source of the textbox.
Thanks again for all your help!