How to bold specific elements from a Database using a SimpleCursorAdapter
<p>I have a main activity that takes elements from a database and displays them in a clickable listview. I use this method to accomplish the task:</p>

<pre><code>private void fillData() {
    // Get all of the notes from the database and create the item list
    Cursor c = RequestManager.getRequests(getApplicationContext());
    startManagingCursor(c);
    String[] from = new String[] { DataBase.KEY_TITLE, DataBase.KEY_BODY };
    int[] to = new int[] { R.id.text1, R.id.text2 };

    // Now create an array adapter and set it to display using our row
    SimpleCursorAdapter notes =
        new SimpleCursorAdapter(this, R.layout.notes_row, c, from, to);
    setListAdapter(notes);
}
</code></pre>

<p>I am wondering, is it possible to access a boolean field inside the database, and bold the specific element is the field is marked as unread? The elements are each in a textview, and are then placed in a listview. 
Thanks</p>

<p>Edit: Used the suggestion to extend the CursorAdapter Class, but when any element in the list is bolded, the first element is also bolded. Once all the elements are marked as read, the first element goes back to unbolded. Any ideas?</p>

<pre><code>    public void bindView(View view, Context context, Cursor cursor) {
    TextView textRequestNo = (TextView) view.findViewById(R.id.text1);
    TextView textMessage = (TextView) view.findViewById(R.id.text2);
    StringBuilder requestNo = new StringBuilder(cursor.getString(cursor
            .getColumnIndex("requestNo")));
    StringBuilder message = new StringBuilder(cursor.getString(cursor
            .getColumnIndex("Message")));

    textRequestNo.setText(requestNo);
    textMessage.setText(message);
    if (cursor.getString(cursor.getColumnIndex("Read")).equals("false"))
    {
        textRequestNo.setTypeface(null, Typeface.BOLD);
        textMessage.setTypeface(null, Typeface.BOLD);
    }   
}
@Override
public View newView(Context context, Cursor cursor, ViewGroup parent) {
    final View view = mInflater.inflate(R.layout.notes_row, parent, false);
    bindView(view, context, cursor);
    return view;
}
</code></pre>
