Hi Paresh,
Do you want to disable the dropdown when we select the value in the drop
down or when the dropdown has only one value?
If you want to disable when we select the value in the dropdown. Set the
data validation in the dropdown field as when dropdown is not blank, disable
this control.
Thanks,

Signature
Anuma Reddy
http://www.GGKtech.com
> Hi All,
>
[quoted text clipped - 4 lines]
> Thanks,
> Paresh
Paresh - 18 Dec 2007 10:25 GMT
On Dec 18, 3:11 pm, Anuma(GGK Tech)
<AnumaGGKT...@discussions.microsoft.com> wrote:
> Hi Paresh,
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -
I want to disable the dropdown only when there is only one item in the
dropdown.
Thanks,
Paresh
You can use the count() function to count the amount of items in the
drop-down list box by counting the amount of items in the data source that
the drop-down list box is bound to. Use this in a conditional formatting
condition to disable the drop-down list box when the count is equal to 1.
---
S.Y.M. Wong-A-Ton
> Hi All,
>
[quoted text clipped - 4 lines]
> Thanks,
> Paresh
Paresh - 19 Dec 2007 06:48 GMT
On Dec 19, 6:44 am, S.Y.M. Wong-A-Ton
<SYMWongA...@discussions.microsoft.com> wrote:
> You can use the count() function to count the amount of items in the
> drop-down list box by counting the amount of items in the data source that
[quoted text clipped - 13 lines]
>
> - Show quoted text -
Thanks SYM. I will try this out and let you know the updates :)
Regards,
Paresh
irenestasney@gmail.com - 12 Jan 2008 01:33 GMT
> On Dec 19, 6:44 am,S.Y.M.Wong-A-Ton
>
[quoted text clipped - 21 lines]
> Regards,
> Paresh