Change Address_1 Field type to multiline instead of Text Field

[Andrew]

Hi. On my Virtuemart 3.4.2, joomla 3.9 site, I want to change the Address Field (Address_1) to a multiline field instead of just a one line text field. If I edit it under Shopper Fields, I can see that it is Text Field but can't edit it. Would it work if I create a new field and call it the same name? Site is live and don't want to muck it up! The reason I need to change it is that we are using a drop ship warehouse that can't handle the second address line. It is coming through but not printed on the label.
Thanks for any help
Andrew

[GJC Web Design]

if u delete a shopper field it is renamed in the table -- when u make a new same named it will create a new column

is prob easier to change directly in the table to textarea

#__virtuemart_userfields

u need to check how the multiline saves as well

[Andrew]

Thanks John!

[Andrew]

I did have a prob when I unpublished the address 2 field. Users couldn't register any more. Have published it and hidden it. Works fine now.