Formatting One part of an Expression Text Box

[rhuns]

Hi all, drawing a blank and need some assistance. I have a report with several text boxes (City, State Zip) that I am condensing into one. The text box that displays on the report has a control source set to

=[txtclientcity] & "," & " " & [txtclientstate] & " " & [txtclientzip]

This is all functional, problem is, almost all zips begin with a "0" via the area. Zip is stored as a number but displays correctly elsewhere via formatting. Is there a way to format only the "[txtclientzip]" part of that control source?

Thanks in advance.

[MikeTheBike]

Hi I don't know how many characters there are in a zip code but maybe something like this
=[txtclientcity] & "," & " " & [txtclientstate] & " " & Format([txtclientzip],"0000")

??

MTB

[rhuns]

Hey Mike, that's the one! Thanks for that :)