Report field loses format when concatenated 1

[Hillary]

There is an autonumber field in the database that is formated 0000 so it always displays 4 digits (ex. 0001, 0100, 1000). In the report it works fine until I concatenate this field with a date field.

Here is my formula...
EC Label: "EC " & Right([Start Date],2) & "-" & [Concept Data.EC Number]

The result is EC 02-1. I expect to see EC 02-0001.

Any ideas on how I can keep the 0000 format for Concept Data.EC Number?

Thanks for you help.

Hillary

 

[JohnLowell]

Change the column definition to this:

EC Label: "EC " & Right([Start Date],2) & "-" & Format([Concept Data.EC Number],"0000&quot