#Name Error on Report control box expression

[djai695]

My report was working previously with this expression:

=IIf([Expr1]="BLANK","",CDate(Mid([Expr1],5,2) & "/" & Right([Expr1],2) & "/" & Left([Expr1],4)))

Basically, "Expr1" is a field on the query coming from a table, which displays a date string. My expression makes the text box display the date as ##/##/####.

For some reason, when I run the report now, the field comes up as "#Name".

Any tips?

 

[pr2-eugin]

#Name indicates that the Name you are trying to refer to is misspelt or incorrect. Check for the any mistake, refer the controls correctly.