I'd just love one or two commands for doing this.

Any clues?

If it were excel, I'd record a macro doing it and butcher the code, but Access doesn't give you the option of recording the macros. Why are MS so inconsistant in features across the Office range?

Cheers,

-Andy