criteria Input mask

[tcommis]

Hello all - Is there a way to have an imput mask for you criteria in a query? I'm asking for a "short" date, (I don't want it displayed in the query though, not sure if that makes a difference) and right know I'm relying on the operator to type it without an input mask, which is causing some problems. any help would be great.
Somewhat of a newbie here so please bear with me if this question is simple.

Thanks

Tcommis

 

[Fizzio]

If you want to be able to use an input mask, get the criteria from a form control and set the input mask there.

 

[tcommis]

I was afriad some one would say that. I've tried that a couple of times with no luck and not sure where the problem is to even post it here.

Thanks anyway - until I can get to the cause of the problem with entering it with a form I'll have to stay the course for now.

Thanks!

Tcommis

 

[Kinger43]

I have a form control with the input mask on it for a phone number. I am using an append query to append the information entered in the form to a table. I need to pull two fields from a linked table from another database. What I need to do is be able to compare the entered phone number in the form with the phone number from the table. The problem I am running into is that it won't match the phone numbers. The same mask is used in the table I am pulling from. Why can I not just put =

.[Phone_No] in the Criteria of the field where the number from the form is placed so that I can get the right record from the linked table?