Why is this happening: If Me.Combo6.Value = "CLIENT1" Then wont work

[pedie]

Hi, I know that Combo6 value = CLIENT1 withot any spaces...
however it always returns "MsgBox "No " & Me.Combo6.Value
I also tried If trim(Me.Combo6.Value) = "CLIENT1" Then
Still the same...
Is there some reason this can happen in access form?

Thanks for helping.

[/FONT]
[FONT=Courier New]Option Compare Database[/FONT]
[FONT=Courier New]Private Sub Command8_Click()
 If Me.Combo6.Value = "CLIENT1" Then
 MsgBox "Yes " & Me.Combo6.Value
 Else
 MsgBox "No " & Me.Combo6.Value
 End If
End Sub

 

[shg]

use the StrComp function if you want a robust solution ...

Got that, do that, done that.

My point was just to understand if the intrinsic VBA behavior is different between Excel and Access, and it seems that the answer is no, they are the same, but Option Compare Database, apparently always used in Access, has has the same (or broader) effects as Option Compare Text.

 

[dk]

And one more page that recommends a) generally use Option Compare Database to respect the sort order of the database in Access databases and b) use the StrComp function if you want a robust solution that works the same no matter what Option Compare is used ... (I think this is what dk was saying above).
http://www.fmsinc.com/free/NewTips/VBA/Option/index.html

Yes, that's exactly what I was saying. Same with using Option Base 1 - I'd rather just use Lbound and Ubound so that way I can safely reuse functions (across Excel, Access, Word) and not have to worry about whether I have the correct module level settings.