Switch() function results in #Error

[Guest]

I have a field with a single character code in it and want to display the
corresponding word on a report. When I put the following in a textbox Control
Source param. I get #Error displayed on the report. Any ideas?

=Switch([RecType] = "D", "Deceased",[RecType] = "S", "Suspended",[RecType] =
"P', "Prospect")

 

[Douglas J. Steele]

If that's an actual copy-and-paste of what you have, you've got a single
quote after the P in [RecType] = "P'

 

[Marshall Barton]

I have a field with a single character code in it and want to display the
corresponding word on a report. When I put the following in a textbox Control
Source param. I get #Error displayed on the report. Any ideas?

=Switch([RecType] = "D", "Deceased",[RecType] = "S", "Suspended",[RecType] =
"P', "Prospect")

Also, make sure that the text box is **not** named RecType