Switch() function results in #Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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")
 
If that's an actual copy-and-paste of what you have, you've got a single
quote after the P in [RecType] = "P'
 
bkaufman said:
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")
Click to expand...


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