Format Zip Code as Zip plus four if 9 digits - Paginated Report

[mrscherry2000]

Good Day,

I'm trying to create an expression to display a Zip Code as #####-#### if it is 9 digits or as ##### if it is 5 digits.  

Can anyone point me in the right direction?

[mrscherry2000 · Accepted solution]

Figured it out:

=IIf(Len(Fields!Zip.Value) = 5, Fields!Zip.Value, Left(Fields!Zip.Value, 5) &"-" & Right(Fields!Zip.Value, 4))