Try suffixing this to your formula:
… & Right( "000000" & your_order_id ; 6 )
P.S. There is also a function called SerialIncrement( text ; incrementby ) if you need it.
You are absolute star. So simple yet effective :). Thank you!
Even simpler would be to leave off the initial altogether as adding that detail unnecessarily complicates the ID number generation process. If you must use this format in order to support a legacy process or the expectations of your users, do not use it as your table's primary key.