The Access Search Seminar covers this.

That would be great if I had $230. I'm on a fixed income (Social Security only) and can't afford any seminars.

Stephen,

please give more details of the problem you are having, and we will try to help you.

Search Form 2.0

On the search box set up a on Keypress Event.  KeyAscii = 32 is the space key

Private Sub MySearch_KeyPress(KeyAscii As Integer)
    If KeyAscii = 32 Then
        blnspace = True
    Else
        blnspace = False
    End If
End Sub

And then using the Search Form 2.0 change() event or however you did yours.

Or maybe you could use a wildcard * when you intend to use a space?

Thank you all.  I tried using Jeffrey's suggestion, and itdid put a space when I checked for KeyAscii - 32, but it put a space before what was in the Search Text box. Here is the code I used:

Private Sub SearchBoxAddr_KeyPress(KeyAscii As Integer)

    If KeyAscii = 32 Then
        Me.SearchBoxAddr.SetFocus
        Me.SearchBoxAddr.Sel = Len(SearchBoxAddr.Text)
        Me.SearchBoxAddr.Text = Me.SearchBoxAddr.Text & " "
        
    End If

End Sub

Private Sub SearchBoxAddr_KeyDown(KeyCode As Integer, Shift As Integer)

    If KeyCode = 32 Then  ' Check if the Space key was pressed
        ' Prevent the default handling of the space key
        KeyCode = 0
        
        ' Manually add the space to the text box value
        Me.SearchBoxAddr.Value = Me.SearchBoxAddr.Value & " "
        
        ' Set the cursor to the end of the text
        Me.SearchBoxAddr.SelStart = Len(Me.SearchBoxAddr.Value)
    End If

End Sub

Well, thank you Lars. It Finally worked, but with one change in your code: I changed "KeyCode" to "KeyAscii". Once again, thank all of you who helped.

Great that it worked out.
You had probably used KeyPress and not KeyDown and therefore needed KeyAscii.

Incidentally, the code was not my idea either, but the result I was able to achieve with ChatGPT after ChatGPT had first tried quite a lot of nonsense until I gave it the right link, which ChatGPT was then able to enlighten after all:
https://599cd.com/blog/display-article.asp?ID=2777