Only Allow specific input

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rod - 30 Nov 2005 04:52 GMT

I am using speech recognition. When it is determining what you "said" it
places a "." as a placeholder and removes the "." when it is done. I have a
field which is text and is for phone numbers. I need to tell Access 2003 to
accept "." and 0-9but not accept the "-" which Access places in the phone
number automatically; I store the number as 1234567.

Suggestions?

Thanks.

Reply to this Message

Arvin Meyer [MVP] - 30 Nov 2005 11:21 GMT

Try removing the input mask and see if that gives you what you are looking
for. If there is no input mask, the format property is changing the display
of the textbox, without actually changing the data. You can change the
format property and get what you are looking for.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

> I am using speech recognition. When it is determining what you "said" it
> places a "." as a placeholder and removes the "." when it is done. I have a
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message