You can go many different ways; so without knowing your 200 codes, I can give a preferred suggestion; but it may not work for your situation. If the characters are a consitent length, you could use queries and tables to get what you need. Example:
Make a table called ActionTable and add columns Action and Description. Create rows like this:
Make a table called TimeTable and add columns ActionTime and Description. Create rows like this:
Now build one query that separates the Translation column into 2 columns from your table where the data entry is being done.
Select *, left(Translation,1) As Action, Mid(Translation,2,Len(Translation)) As ActionTime SomeTable
Now build a second query that joins the first query to the tables created earlier:
select * from query1 inner join ActionTable on query1.Action = ActionTable.Action inner join TimeTable on query1.ActionTime on TimeTable.ActionTime
This second query will allow for the descriptions of each code to be displayed. This way you can have your codes in a table rather than “hard Coded” using Case or IIF