IF statement

[Harrild]

is there a limit in VB on how many elseif commands you can have in an if statment/

[gfk]

There's no limit on the amount of 'else' commands you can use.

The amount of nested If... EndIf statements is limited, and depends on the amount of free stack space. Generally you won't need to worry about it as it's a ridiculously high number.

[Stevie]

If you're using that many ElseIf's why dont you use a Case statement.

[Harrild]

when i want to search for a field and the released field i do not get any results, just the field names and thats it.

[Stevie]

What?????

[Harrild]

that last post by me wasn't meant to go here. It was meant for another thread.

[Stevie]

Ahhh. Thought I was going mad.