Showing different data than in database

[ravenge]

Hey there,

I am stumped on this and am asking for some help/advice.

I have an access database and can show the records in a datagrid no problems. In the database one of the colums is name status and have the value -1, 0, 1 and 2

What I would like to know is how to I show different values in my datagrid based on those values.

For example, where the value is 0 I would like display "Pending" in the datagrid and where the value is 1 I would like to show "Accepted" and so on.

Thanks in advance!
JB