Does VB lie? Help with an If/Then that doesn't work

[D'Anconia]

Hi, all!

There's got to be something right in front of my face that I'm mising, but I don't get this. I have a form with a few drop downs. I don't want any others to be enabled until there's an entry in the first one (DDAudPer). I test this by checking the length of DDAudPer.Text in the field's OnChange procedure. Once an entry is made the others are enabled and I can make entries there. But if the first one is changed back to a blank, I want the other dropdowns to have their entries removed, and to be re-disabled. The if/then is suppposed to acheive this, but it executes the code for the length = 0 regardless of what it actually evaluates to. The code is seen in the graphic below. It shows that the debugger went to the 1st line of code as if the length<>0, while the ImmedateWindow shows it evaluating (properly) to 0.

Any help will be appreciated!

[orange]

Re:Combobox ---I think this is your issue
The Value property is set to the text in the text box portion of the control. This may or may not be the same as the setting for the Text property of the control. The current setting for the Text property is what is displayed in the text box portion of the combo box; the Value property is set to the Text property setting only after this text is saved.

The Value property returns or sets a control's default property, which is the property that is assumed when you don't explicitly specify a property name.

see this for details

Try
Debug.print Len(DDAudPer.Value) and Debug.print Len(DDAudPer.Text)

[June7]

Aside from dropping the .Text property, consider BeforeUpdate event instead.

[D'Anconia]

Thanks to you both! It's quitting time now, so I'll try these suggestioins tomorrow and let you know if they resolved the problem.

I really appreciate your speedy responses!

[trevor40]

(debug T, to check the value if you need to)
T= me.DDAudPer
If IsNull(T) then
....
else
....
end if

[John_G]

Hi -

You have your code in the wrong event. The On Change fires as soon as you make ANY change in the field, e.g. deleting a character.

Try putting your code in the After Update or the On Exit event instead.

HTH

John