Parameter with wildcard

[cathyg18]

In Access 2003 is there a way to base a parameter selection on a partial string using wildcards? For example, I want a user to input 'CAT' and return records containing 'CAT', not just records that exactly match 'CAT'.

Thanks.

Cathy

 

[RoyVidar]

In a report?

That would probably be when opening the report, say something like the following air code

[tt]DoCmd.OpenReport "TheReport", acViewPreview,,"TheField Like '*" & Me!txtTheControl.Value & "*'"[/tt]

TheField - the name of the field
txtTheControl - the name of the control holding your criterion on the form

Roy-Vidar