Hiding a column in a List box

[#1]

Hi,

Can you hide a column in a list box. I've got two columns the second is an expression, I would like to hide the first one.

Rgds

Graham

[sudeepkm]

I think you want to hide the Field in the List box and keeping the expression only visible.

That you can do it by selecting the divider line (invisible by default) between the Field and the Expression of the List box and then drag to the left like below.

[sudeepkm]

Just wanted to check what exactly you will get if you do so. Hiding the Dimension field may not make sense as the end user will never be able to understand the number without any references.

Also just to show the number it is better to use as suggested by tresesco instead of dragging the divider line.

[DavidFoster1]

Alternatively look at the DUAL function as an option for a text value with a numeric equivalent value.

[fernando_tonial]

Use the function Macth()

Match(Departments,'Sales','Payments','Departments1',.....)

[#6]

Hi Tresesco,

This gives me the order 1 - 6, but I also need the name of the department next to the correct number. (i.e. 1 = Sales, 2 = Payments etc...)

[tresesco]

Second expression, simply: =Departments   ?

[#8]

Hi Sudeep,

How do you unhide the divider line?

Cheers

Graham

[sudeepkm · Accepted solution]

I do not think in a List Box that (A Straight Table or Table box cell look alike) is possible.

In List box we can only enable horizontal Cell border.

[jagan]

Hi,

Please find attached file.

Regards,

Jagan.