MS Access Visual Basic-------Need Help on IF Condition

Instead of giving this like large formula anybody can help me and try reduce the size of formula.....

Please Login or Register  to view this content.

Suggest you look at the Case statements. Here is a quick tutorial.

http://www.techonthenet.com/access/f...anced/case.php

Alan

bsaimsc,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.