I use a 4GB microSD card in my Curve. Many report no problems with larger capacity microSD cards (ie 6gb). I believe 8GB the largest currently available and it should work.
The Curve is great to use as a music player. I have 80 CD's on my 4GB card with room for photos and ringtones!