Grey out a combo box based on a date range in another combo box

[Gary Childress]

Hi,



I'm trying to make a combo box grey itself out if a date in another combo box is between two particular months of the year. So for instance if the date chosen in the drop down menu of Combobox1 is between March 1st and June 30th, then I want Combobox2 to grey itself out. I've tried this using conditional formatting and for some reason can't get it to work.

This is the expression I first tried to use in a conditional formatting rule for Combobox2:

([combobox1].value>3/1/14) and ([combobox1].value<6/30/2014)

For some reason this doesn't seem to be working the way I want it to. When I pick a date that should grey out Combobox2 it doesn't grey it out. I've also tried the rule below and it doesn't seem to work either:

([Combo262] Between 3/1/2014 And 6/30/2014)

I'm at my wits end. Any help would be greatly appreciated.

Thank you!

[amrut]

Date fields should always be surrounded with "#" character like Between #3/1/2014# And #6/30/2014#.
Further, conditional formatting will only apply a format but cannot grey it i.e. disable it so that users cannot select it. To achieve this, you need to use vba code in combo1's afterupdate event.
If Me.Combo1 Between #3/1/2014# And #6/30/2014# then
Me.Combo2.Enabled=False
Else
Me.Combo2.Enabled=True
EndIf

[Gary Childress]

Date fields should always be surrounded with "#" character like Between #3/1/2014# And #6/30/2014#.
Further, conditional formatting will only apply a format but cannot grey it i.e. disable it so that users cannot select it. To achieve this, you need to use vba code in combo1's afterupdate event.
If Me.Combo1 Between #3/1/2014# And #6/30/2014# then
Me.Combo2.Enabled=False
Else
Me.Combo2.Enabled=True
EndIf

Thanks you amrut! It seems to be working now.

[amrut]

Glad to help ! Mark the thread as solved