As I thought, the problem wasn't with the number of ORs strung together. The
is either a typo, a exttra blank character or an invisible character in the
string you are searching.
try something like this
for i = 1 to len(mystring)
msgbox("Char: " & i & "=" & _
mid(mystring,1,1) & "=" & _
asc(mid(mystring,1,1)))
next i
"Matts" wrote:
> Hi Joel,
> Only the first half is getting checked (TempOR1).
> Doesnt seem to work for the values in the (TempOR2) argument.
>
> What next ?
>
> "Joel" wrote:
>
> > Easy
> >
> > TempOR1 = (Me.CboSubType.Value = "Blue") Or _
> > (Me.CboSubType.Value = "Blue MGM") Or _
> > (Me.CboSubType.Value = "Gold") Or _
> > (Me.CboSubType.Value = "Gold MGM")
> >
> > TempOR2 = (Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]") Or _
> > (Me.CboSubType.Value = "Citi-Plus") Or _
> > (Me.CboSubType.Value = "CG Fee Account")
> >
> > if (TempOR1 or TempOR2) and (Me.CboType = "New to Bank") then
> > Me.Label7.Visible = False
> > Me.txtVlu.Visible = False
> > Else
> > Me.Label7.Visible = True
> > Me.txtVlu.Visible = True
> >
> > "Matts" wrote:
> >
> > > Hi,
> > > Is there a limit to the no of 'OR's in a statement, cos in the below condition
> > > the 1st 6 conditions get checked, but not the last checking criteria
> > > [*****],refer below.
> > > (also another simple Q, how can i break the lenght of the code
> > > & continue typing it on a next line ?)
> > >
> > > If Me.CboSubType.Value = "Blue" Or
> > > Me.CboSubType.Value = "Blue MGM" Or
> > > Me.CboSubType.Value = "Gold" Or
> > > Me.CboSubType.Value = "Gold MGM" Or
> > > Me.CboSubType.Value = "Citi-Access [Sal. Dom Only]" Or
> > > Me.CboSubType.Value = "Citi-Plus" Or
> > > Me.CboSubType.Value = "CG Fee Account" [*******] doesnt check this ! !
> > > AND
> > > Me.CboType = "New to Bank" Then
> > > Me.Label7.Visible = False
> > > Me.txtVlu.Visible = False
> > > Else
> > > Me.Label7.Visible = True
> > > Me.txtVlu.Visible = True
|
Similar Threads
