To make Access start at the beginning of a word in a text box on a form rather than selecting the entire word (which makes it easy to accidentally erase), the following line of code in the 'Got Focus' event procedure of the text box will fix this:
Me.name_of_text_box.SelStart = 0