How to change the Number field back to string?

[bgn]

I mistaskenly manually changed the Number field type from String to Reference while OOB configuration is set to String .

I did it in a table which extends the Task one.

Does anyone know how i can fix it?

Thanks

[nR9]

Yes,

You can change that.

There are 2 ways.

• Go to System Defination >> Dictionary, locate the field and make changes
• Open the form, right click on the field and make the necessary changes

A thing I want to add here is, if you have created any record with the previous datatype, all the data will be deleted when changing the datatype.

hope this helps.

[bgn]

Thank you for your answer.

Option #1 : after updating the Task table it's written : "Type unchanged for field "Number". Cannot convert from Reference to String." And I don't understand why. The Task table is the only one where the type is Reference instead of String or Integer.

Option #2 : it doesn't work either

[venkatesh_chakk]

Hi,

When you are trying to change the field Type it will give the following error "Your changes will remove all field data from Beer or Wine in table Food Service. Continue?". Once you update the Field Properties the data in that particular field will be lost. If you are OK for that you can modify the field property.

Following are the Steps to update the Field Property

1. Open the form

2. Right Click on the field

3. Select the Option Personalize Dictonary

4. Select the required Type (String, Date, Image, Decimal etc.) as per your requirement

But Keep in mind that you will be getting the following warning ""Your changes will remove all field data from Beer or Wine in table Food Service. Continue?". and all the data pertaining to that field will be lost.

Thanks,

Venkatesh Chakka

[daveness]

I have the same issue, and I'm getting the same results as bgn, "Type unchanged for field "Number". Cannot convert from Reference to String." I've used both methods, modifying the Type from the System Definition >> Dictionary, and from the form itself, same results.

I've tried this with elevated privileges to no avail. Am I missing something?