Select an object or group of objects on the menu go to Format|Align
As far as the other issue with missing data I can not be of much help since I do not have the code/data to play with. What version of Access are you using? You might want to put a debug.print statement in your code so you can troubleshoot....
Ricardo A. Parodi
eSolar, Inc.