From your question, I'm assuming you are using an Ubuntu autologin, and it is only the sleep mode that is a problem.
From the command line you can delete your password using:
Code:
sudo passwd -d username
and then the user will be able to set a new password in the usual way.