Search button on a form

[Peter_M]

I have a button on a form to find a house - in a village of some 200 houses
this works well except when searching for a house # with two digits eg. 36


the search will also find House 136
My question is

how do I code this search to ensure that the Match is set to Whole Field in the Find and Replace?

[June7]

Post your code.

Review https://stackoverflow.com/questions/...ult-access-vba

[ranman256]

Do not use the asterisk.

[June7]

@ranman, don't think they are using asterisk. They are opening the Find & Replace dialog and it is defaulting to "any part of field" for match.

[CJ_London]

Agree with June, think the OP is talking about the Find and Replace form. This link should help

https://docs.microsoft.com/en-us/off...ss.acfindmatch

looks like the match parameter needs to be set to 1

[Welshgasman]

Example here as well
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.findrecord

[CJ_London]

that is probably a better link!

But does say the default is entire?

[Welshgasman]

that is probably a better link!

But does say the default is entire?

We do not yet know what the OP is actually using?

[CJ_London]

true