Thanks for your help.
(see attached file)
However, I must be doing something wrong cause I can't get it to work. I put the appropriate code in the on got focus event of the fname text box. When I click in that box it does not highlight the text. Also this is Access 2007 so i can't find the...