Wildcard charater? 1

[HandJT]

I have a drop down menu box with several options. For some of the options, they have specific activities to do so I listed those in my code specifically. However, for the other options, which are 12, there is only one thing for all of these to do. In my code I put:

If OperationName.value <> Null Then
I also put
If OperationName.value = "*" Then
and
If OperationName.value = <> Null Then

It will not execute either way I try to use a wildcard. Is there other options I am not aware of that I could use that will execute the command when one of the other 12 options are selected?

Thanks in advance!!

 

[kjv1611]

Maybe try:
If OperationName <> "" Then

Or

If OperationName.Text <> "" Then

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[PHV]

Have you tried something like this ?
If Len(Trim(OperationName.Value & "")) = 0 Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[HandJT]

Thanks a lot! The first one posted from kjv1611 was perfect!! It worked perfectly. Sorry PHV, this was the first one I tried.