Display a Number as a Letter

[Guest]

I'm using Access 2000. I'm inputting a number in a form always a "1". When I
open another form I want that number 1 to display as "BT". Any help would be
appreciated. Thanks in advance. Paul

 

[Douglas J. Steele]

Can you create a table that translates 1 to BT and use that table?