Active Forms with Picklist

[kangkc]

I have been looking for ways to disable Picklist in Active Form but just can't find a way.

The picklist is manged through a control cube and it's required for input via cube viewer. However the Active form is more for reporting and the picklist is slowing down the whole active form as one of the picklist cell have a long list of elements.

I have tried looking at the formatting area but there isn't any formatting control, neither on the 1st row of the active form.

It seems to be the DBRW that automatically transform the cell into a picklist. Any suggestion ?

[Andy Key]

Change your DBRW formulae in the first row of the active form for any columns that have picklists on them so that you enclose the DBRW in parentheses.

i.e. change

Code: Select all

=DBRW(<tm1rptviewref>, <dimref1>, <dimref2>, <etc>)

to

Code: Select all

=(DBRW(<tm1rptviewref>, <dimref1>, <dimref2>, <etc>))

As you already have a picklist on that column, you will have to delete the formula and then re-enter it from scratch (or paste and edit it in the formula entry box) otherwise it will complain that your new formula isn't one of the acceptable values.

[kangkc]

Thanks. Works pretty well.

Actually you do not need to empty the cell, just Clear the Data Validation on the cell before changing the DBRW. Save some time if you have many cells to handle.