ShowColumn on the fly?

v-man

Does anyone know how to be able to not show certain columns based on user permissions? I have set the visible := false; but, the user can still right-click and do a showcolumn. I need to be able to remove the column based on user permissions.

Does anyone have any ideas?

JohnP

You can't remove the column but you can make it not editable in the same way as you make it not visible then even if the user shows the column they still can't change it. If this is not satisfactory either then you will need a new form where the column is not available and also prevent the user from using the zoom function (which will then prevent them using zoom anywhere on the system).

Cheers,
John

mfabian

VISIBLE=False only helps if you revoke the right to (de)activate columns.
Setting Editable to false will still allow the user to read the column. If this is not desired (e.g. confidential information) you might set the foreground color to white, thus displaying the data in white writing on white background which of course appears like a empty white column.
Alternatively you might also use the OnFormat trigger of the column(s) in question and blank out the real information.

Marcus


[This message has been edited by fabian (edited 08-07-2001).]