I am trying to figure how to format an autonumber ID field in Microsoft Access to a five digit format. I have tried in the format field to do this with five zeros. For example 00000, but it just places 4 zeros in front of the last number.

This is how I have it for right now.

This is how it's supposed to be.

E Ship X Pass_ID : Passenger X - Cruise_ID = Cruise X 3 Reservation X Res_TotalCost Res_BalanceDue - Res_SpecialRequest $1,009.00 $509.00 $1,449.00 $949.00 Low Salt $1,422.00 $922.00 Vegetarian $1,029.00 $629.00 $1,714.00 $714.00 Vegetarian $1,299.00 $799.00 $1,209.00 $959.00 Kosher $1,209.00 $959.00 Kosher Res_Room F432 B323 B222 C132 D323 A800 H900 H900 - Res_Deposit - Click to Add . $500.00 $500.00 $500.00 $400.00 $1,000.00 $500.00 $250.00 $250.00 Cruise_ID Pass_ID - 11111 11111 22222 33333 44444 44444 55555 66666 - Res_TotalCost - Res_BalanceDue - Res_SpecialRequest - Res_Room $1,009.00 $509.00 F432 $1,449.00 $949.00 Low salt B323 $1,422.00 $922.00 Vegetarian B222 $1,029.00 $629.00 C132 $1,714.00 $714.00 Vegetarian D323 $1,299.00 $799.00 A800 $1,209.00 $959.00 Kosher H900 $1,209.00 $959.00 Kosher H900 - Res_Deposit - $500.00 $500.00 $500.00 $400.00 $1,000.00 $500.00 $250.00 $250.00