I am displaying records from an MS Access Database. One of the fields is the person's marital status. To conserve on space, I have stored it as a short Int: 0=Unknown, 1=Single, 2=Married...etc. What I'm trying to do is convert that numeric value to the textual value when it is displayed in the DatagridView. I am toying around with some ideas but they all seem too time consuming. Does anyone have any ideas on how to go about this?
Loading
Ebin RoyPosted Jul 20, 2007, 11:40 AM
Better do checking from database using iif function in access
http://www.techonthenet.com/access/functions/advanced/iif.php