Yes, I've deliberately put a row of data in the source table which causes part of the process to fall over with message:

Msg 241, Level 16, State 1, Line 25

Conversion...

Apologies if I've missed the point but why not just apply code 'C0' to the textbox format property?

Paul

Sorry for the late reply but I figured it out in the end.

Because I hadn't done this in a long time I was trying to set the variable in the...

Thanks Dave, I'll look into that.

Best regards,

Chris

Hi there,

I tried to attempt a similar thing with one of my reports a while ago, for the same reason. Unfortunately, to the best of my knowledge, it isn't...