Rob, you'll have to do a LOT of research on this one. Most composite screens out there cannot take a regular VGA signal without some kind of input controller that already does VGA.
Here is my tutorial for the PSone screen mod.
P.S. The quality still sucks, but was better than composite.