.SetFocus code to alow space

S

Simon

I have the following code on a form that is based on a query, what it
does as i type in post code ( zip code) it requry every time to show
closest match

Code is

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 is if i try to do a space it does not work

If it try to type the followin postcode po34 5gs it comes up as
po345gs how do it code it so it always spaces
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set focus after re query 0
Set Focus on Requery Propblem 2
post code / zip code search 1
type mismatch error in macro in excel 0
No Current Record - Before Code Even Runs! 0
SetFocus Problems 2
Help with code 3
Move local File to a shared drive,this not work on 2 & 3 athattach 0

Top