Access selecting all text when typing?

[willbo987]

Hi there.

I have created a database.

On opening the [Company] form opens up.

After pressing the 'Add new company' button it creates a new record.

However, when typing immediately into the 'Company Name' field, access highlights all the text whilst your typing making you delete what you have just typed.

I have tried several macros and vba at various different events to try and solve including 'Gotocontrol', 'refesh'. I have even tried SelStart.

Can someone please help!!!

I have attached for your help

 

[boblarson]

Get rid of the ON ENTER embedded macro on that combo box.

 

[willbo987]

Hi Thanks for the quick reply.

I might be missing something here... I cant see an ON ENTER macro.

I had some left over macros where I was trying to fix the problem but i have deleted them now and the same problem occurs?

Thanks again

Will

 

[boblarson]

Oh, sorry about that. I was looking at Combo70.

Open Access Options from Access and go to the ADVANCED selection (I'm using 2007 at the moment so with 2010 they may be in slightly different locations) and then under the EDITING category there is a BEHAVIOR ENTERING FIELD. Change that from Select Entire Field to Go to Start of Field or Go To End of Field depending on what you want.

 

[willbo987]

Hi Thanks for all your help.

I SOLVED IT IN THE END!!!!

You was kinda right.

There was a ON ENTER macro 'Saving records' on one of the subforms (The Operator Licence subform) within the main form.

This i assume was refreshing and saving the record when i started typing.

Cant even remember why i had it lol

Thanks