Hi Joeyt66
I finally started making the big switch to sand, and am absolutely delighted with the results so far. I have changed over 8 tanks in the last 10 days, and only one gave me any trouble clearing up. That one took until the next day to settle completely, while the others cleared within a few hours.
The sand I used was inexpensive play sand which I got at Home Depot for $2.89 per 50 pound sack. Play sand, since it is intended for use by very young children in their sandboxes, is smooth and rounded so it's perfect for use in fish tanks. Even cory cats, with their delicate barbels, will not be harmed by it.
I found it very clean and free from debris, but the finest particles are like silt, and that is what must be rinsed away. I found washing it with warm water, in a dishpan, a few cupfuls at a time, was quite soothing and relaxing and not at all as bad as it sounds. It's worth the time and effort to do a good job at this stage.
Another benefit of sand is that you don't need as much of it as gravel. It should not be more than an inch or so, I have been told.
The beneficial bacteria in your filter should be enough to carry your tank through, unless it is very overstocked, until a colony becomes established in the sand. Just check your chemicals regularly, and do some extra water changes if necessary.