Hi
Using access 2003 is it possible to change the type of a field from text to combo/picklist without data loss? Whenever i use the Lookup wizard it warns me that all the data will be lost when I try to change it.
I have a field in which the user is typing the same 4 values over again so it makes sense to change the field to a picklist. There are 400 records so I'd rather avoid having to go through each record and re enter the data.
Using access 2003 is it possible to change the type of a field from text to combo/picklist without data loss? Whenever i use the Lookup wizard it warns me that all the data will be lost when I try to change it.
I have a field in which the user is typing the same 4 values over again so it makes sense to change the field to a picklist. There are 400 records so I'd rather avoid having to go through each record and re enter the data.