hi all~
i am currently doing a report using access97. i am quite new to vba so i am not sure if i am able to do this anot.

this is the situation:

I got a table with abbreviations. Eg. A = Apple, O = Orange. But I only keyed in A and O in my table. However in my report, i want my txtbox to display Apple instead of A when it was looped out into the txtbox.

my question is:

can i write a select case to generate out the words? if it is possible, how to use the code builder cause i notice the coding is a little different from the way i code using vb.

Thanks in advance~~
cheers,
stupidz