Spaces in Search As You Type - Microsoft Access Developer 8


	Back to Access Developer 8 Comments List

Upload Images Link Email

Spaces in Search As You Type

Adam Schwanz

5 years ago

Hello Richard, I have this working I believe with a macro to open the selected customer as well, however I'm unable to add spaces into the text field. I may be missing the obvious but how can I add spaces so I can do like Fort Myers, Fort Lauderdale etc without just searching the last word?

	Richard Rost 5 years ago
Yeah, that's a tricky one. I'll have to think about it. The way I have the code written (if memory serves, it has been 2 years since I recorded that) every time you press a key the string gets "trimmed" so the trailing space would be removed. All I can think of is you'd need to keep a second hidden text box or memory variable with the actual value you type in that doesn't get trimmed.

Todd Auer

5 years ago

I was able to accomplish the spaces by:
1.Make list box. Go to properties, select row source "...", Expr:1 [field 1] & [field 2]
2.Make a SearchBox. Go to properties and set the On Change with Code builder type DoCmd.Requery "List Box"
3.Like "*"& [Forms]![Form Name]![SearchBox].[Text] &"*" The .Text will select the text inside of the searchbox

I am also wondering how to make this happen with VBA, can't wait for the update. Thanks!

	Richard Rost 3 years ago
See my note on the lesson page under the "Space Problem" heading.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer 8.