Change Custom Field from Text to Auto-Number

Change Custom Field from Text to Auto-Number

Hi,

I've created a Custom Module to record Tenancy Information. The module has automatically created a Custom Field labelled  Tenancy Name

This Custom Field is a mandatory Text field. 

How do I change the Field Type to an Auto-Number please?

Many thanks,
Craig.


Info

Moderation Update:

We have a separate post that discusses the need to change the default field's type to auto-number and vice versa in the custom module. Please follow the below topic to stay updated of the progress.