Autonumber goes up in the 1,2,3... sequence. Is there any way to customise this to another code like BS0001, BS0002, BS0003?

Keep a second column to contain your alpha prefix and concatinate the two columns for display purposes. Use the Format() function to get leading zeros for the numeric portion.