Cynthia,
Yeah ive used sand for quite a while now and having good luck with it. I had some worries when my axie got sick and that it was because of the small gravel I had. But in the end found out it was nothing to do with it (thank god!) but still a sock to make me think!
Any way...
I have a vacuum too, but its not a battery one its one you connect to a air pump, it works great.
Ive not found it sucks up much sand just a little if I disturb the sand alot.
I have the natural colour in my tank, yeah it does show up the poo and dead plant matter, but I hover up every day, if I can and find its easier to see anything that needs sucking up, no missing poo!
And I also find little tale and foot prints in the sand which is very cute!!
As for my filter sucking it up... never had a problem... I only have a filter that it for a tank half the size of mine (20% water changed eat week), this is because I found the others were too strong and created to much current in the tank.
Good luck Cynthia, let me know how it goes for you...
Jenny,
If you having problems with your filter sucking up the sand, I think your filter maybe a bit strong for the tank, but as long as its baffeled it should be ok.