I'm at a loss with this one... it's probably something stupid but I cannot figure it out.
I'm getting a #Type! error in a calculated field in an Access report, but it does not affect all the records in the report, and it only appears when the report is in Normal view. The field is fine in Preview. Further, depending on how fast I scroll the report, the error appears at different records. Below is the code for the field.
I'm not sure what other information might be useful.