Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DavJRic
-
IIF Function
Alternatively you could try using the CHOOSE function. That is if your options are sequential numbers starting at 1. e.g answer = choose(columnvalue, valuefor1, valuefor2, valuefor3,....) in your instance NameOfLabel.Caption =...- DavJRic
- Post #7
- Forum: Microsoft: Access Other topics
