User input Criteria

[mattc66 via AccessMonster.com]

Hi All,

I want the user to be prompted to input the Criteria. I know that you use the
[ any words ]. However I only want them to have to enter the first 4
charaters of the data.

I was thinking it would be like this: Like "[Enter the first four characters]
*" That doesn't work. What would be my options?

Thanks
Matt

 

[Allen Browne]

Try:
Like [Enter the first four characters] & "*"

 

[mattc66 via AccessMonster.com]

Answered my own question. Like [Enclude the wild card * in the entry]

If anyone has a better method please share.

Hi All,

I want the user to be prompted to input the Criteria. I know that you use the
[ any words ]. However I only want them to have to enter the first 4
charaters of the data.

I was thinking it would be like this: Like "[Enter the first four characters]
*" That doesn't work. What would be my options?

Thanks
Matt

 

[mattc66 via AccessMonster.com]

That worked great.

Thanks

Try:
Like [Enter the first four characters] & "*"

I want the user to be prompted to input the Criteria. I know that you use
the

[quoted text clipped - 7 lines]

Thanks
Matt