Need search form to remove or select text after enter.

[Ekhart]

So I have a search form that works properly as far as searching goes, but when you enter something to search for and hit enter it will search for that and return results but then the cursor moves to the beginning of the text box you enter the value to search for in. What this leads to is if you immediately type in a new value it puts it to the beginning. So if you searched for 'Jones' then hit enter and start typing something else it will be 'xyzJones'. Is there a way to make it clear what is entered in to the text box or at least select the text after searching so it will overwrite?

[davegri]

That's an Access option.
File->Options->Client Settings->Behavior Entering Field

[Missinglinq]

That's not a setting for a given database, but for all databases run on the given machine...you'd have to do that on every machine running the database...and some users might object!

To empty out the search box, each time you go to use it:

Private Sub YourTextBoxName_Click()
   Me.YourTextBoxName = Null
End Sub

Private Sub YourTextBoxName_GotFocus()
   Me.YourTextBoxName = Null
End Sub

To highlite the current data, on entering the Control:

Private Sub YourTextBoxName_Click()
 If Nz(Me.YourTextBoxName, "") <> "" Then
   Me.YourTextBoxName.SelStart = 0
   Me.YourTextBoxName.SelLength = Len(Me.YourTextBoxName)
 End If
End Sub

Private Sub YourTextBoxName_GotFocus()
 If Nz(Me.YourTextBoxName, "") <> "" Then
   Me.YourTextBoxName.SelStart = 0
   Me.YourTextBoxName.SelLength = Len(Me.YourTextBoxName)
 End If
End Sub

Linq ;0)>

[Ekhart]

Thanks MissingLinq, I am able to use yours for clearing the text field and it does work. I would prefer the selection method but when I use this it is still putting cursor at the start of the text box without selecting. I wonder if this is due to the fact I have the code on the 'After Update' event field?

[Missinglinq]

or at least select the text after searching so it will overwrite

The second code example should do just this...regardless of where the cursor is, when the user starts to type the hilighted text will 'disappear,' replaced by the newly typed data.

Linq ;0)>