Changing What DBGrid Displays

I have two questions about DBGrids in VB5:

i. I have one column in a DBGrid which displays customer status as either (A,S,or I). I would like to have the form automattically change all the As to "Active, Ss to "Suspended" and all the Is to "Inactive". Is there a way I can do this when the form loads.

ii. Sometimes when I run a search the DBGrid returns more records then can be displayed. The scroll bar is visable but it is inactive. How do I make to scroll bar operational so that it can view all of the records associated with a search?

Thanks,
Brandr Beekman
[email protected]

Do you use a data object or code as the source for your DBgrid?

For the second part.......

is the DBGrid enabled i.e. can you edit data in the cells?

if you are displaying data from a database, it would be wise to utilize the features of a relational db and load your data from a query, that does the desired maping from code to full text for you. if you are lading your data manualy, then again you should do the maping before loading the data.

best regards

Sascha

Thanks for your help- I solved the problem! The thing with the scroll bar WAS because it wasn't enabled. Thanks again.

-Brandr