Set Focus on Requery Propblem

[Simon]

I have a field witht he following code on a form.
The form requery every time to search for the closest mathc

Private Sub PostCodeSearch_Change()
On Error Resume Next

Me.Requery
Me!PostCodeSearch.SetFocus
Me!PostCodeSearch.SelStart = Len(Me.PostCodeSearch)

On Error GoTo 0
End Sub


Problem i have is it does not let me put a Space in the text field

How can i put in a space

 

[Gina Whipp]

Simon,

When you say you can't put a space in the field, what does that mean?

You can't press the Space Bar? What happens when you do?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Wayne-I-M]

Maybe ???? you have a key press event

If KeyAscii = vbKeySpace Then
KeyAscii = 0
End If

Doubt it though unless you didn't write the DB
just an idea