Switch vs Table Lookup

Topic

New Reply

Is Switch function popular among Access users?
Why not using a table lookup instead?

Armstrong

Reply | Quote

Replies

In general, using a table to look up values is preferable. It is more flexible, since you can easily add, remove and edit values in the table.

The Switch function is a general VBA function that can be used in Access as well as in other Office applications, but I don’t think it’s used a lot – many Access developers don’t even know of its existence.

Reply | Quote

Hans.
Thanks for your thorough high-value input.
Armstrong

Reply | Quote

Is Switch function popular among Access users?
Why not using a table lookup instead?

As Hans said, alot of people don’t know about it. But only in a very specific circumstance is it an alternative to a table lookup. It is better used as an alternative to nested IIF statements; it is MUCH easier to read. And you might also investigate the Choose() function; another little known function.

Reply | Quote