Using FormSettings

[Former Member]

Hi

I've created a form that uses the SAP B1 Form Settings window in order to set matrix columns to visible/enabled. The problem that I have is that I do not want the user to have the capability of changing the settings for all of the columns in the matrix, only the columns that are UDF's.

I have looked at the Form Settings for some of the system forms and the settings are disabled for some of the columns not allowing for them to be changed. Is it possible to get this kind of functionality for my form. I've tried messing with the SAPbouiCOM.FormSettings control but there doesn't seem to be any properties that you can change to achieve the desired effect.

Thanks

[Former Member]

Hello,

You can change this setting on de column by setting the ones you desire to

column.editable = False for matrix or GRID columns

By setting a column not editable on your code, the native Form settings will disable the option "Active".

You can also use the oSBOApp_ItemEvent to prevent the user edit the text even for each cells using conditions for pval.ColUID or pval.Row.

hope it helps!