Only Allow specific input

[Guest]

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.

 

[Arvin Meyer [MVP]]

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