Editable No in table and Yes on Form unexpected behaviour

fabrizioc

Hi to all, can someone explain me the behavior of flag Editable in table and form ?
I have configured a table with Editable = No on a field and I have Editable = Yes on a Form field that point to the same field.

I suppose that the field wasn't editable but I was able to save the new value.

If I set Editable = No on a table field can a Form override this setting ?

Thank you for your feedback.

Best regards
Fabrizio

vaprog

If you set Editable to No in the table, it defaults to No on the Form or Page. If you explicitly set it to Yes on the control on a Form or Page, the field is editable from there, regardless the setting on the table.

RockWithNAV

Hey Fabrizico,

If you set the Property as Editable = No in any of the places either in Table Fields Property or in Form Field Property it will be set as Non Editable. If you want to make it as Editable then it should be Editable = Yes in both the Places. There's no concept of overwriting first it checks the Table Properties and codes then the Forms.

Kishorm

Vaprog is correct in his answer - I've used this method many times as a quick fix to change data in a field that has Editable set to No on the table.