Hi bitgeek and welcome to Lithosphere,
No. with the default permission set Moderators cannot access member's private messages. Administrators can do it though. Generally speaking: Any user (role) that has the "Switch user" permission can switch to another community user and thereby access any user's PM mailbox.