Mapping of fields

[Yessen]

On my report I pull out fields from Field List and they show up on the report when I run it as 0,1,2

how can I map them to something else that I want to show up instead?

Like A, B, C

 

[gemma-the-husky]

will switch do it?

works like an inline case

switch(myfield=0,"A",myfield=1,"B",myfield=2,"C")

 

[Yessen]

will switch do it?

works like an inline case

switch(myfield=0,"A",myfield=1,"B",myfield=2,"C")

where do i insert this switch?

If I just open my report's VBA code its empty there. How can I make the report substitute all the switches that I have in some sort of function.

I need to have some sort of function that will say sub_format that will be run before it opens and substitute all the fields with all the new mappings.