Newbies hfw Posted February 9, 2006 Newbies Posted February 9, 2006 Is there any way to create an input mask so that the person doing data entry doesn't need to put in the parentheses or hyphens in a phone number? I saw that it can be done with Custom Functions, but there's no way I can justify FM8 Advanced.
comment Posted February 10, 2006 Posted February 10, 2006 You don't need a custom function for this, unless you're doing something sophisticated, like letting the user specify the format. Just define the field to auto-enter the formula, replacing existing value. See here for a possible formula.
Newbies hfw Posted February 10, 2006 Author Newbies Posted February 10, 2006 Thank you SO much! I'm a total newbie. Once upon a time I was at least a novice with Access, but haven't used database software for over 6 years.
Recommended Posts
This topic is 6864 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now