[quote=Roy Dennis;110737]Not recommended but,
You can remove leading spaces in Access by selecting the column then use find and replace. From the Match selection drop down box select Start of field, in the find enter a blank space, in the replace leave blank then hit replace all. If you try this bear in mind that if you ever rebuild the songbook all the changes will be lost.
QUOTE]
it seemed to work ok, it took me a moment to figure out the enter a space in the find field, cause when i deleted the entery it wouldnt let me replace all.
will it apply to the songbook now ?