I have a simple phone number field in a database. I'd like to hear some data management best practice thoughts about how this type of field is best handled.
My own inclination is to use some sort of input mask for data entry, a text field for table storage of 10 characters and then some sort of output masks when displaying this data in a form or report. I'm sure most of you have much more experience than me thinking about this. Perhaps integers would be better than text for the table storage. Perhaps you can tell me what terminology Access developers use for input masks and output masks and thus I could look up the correct reference pages for those activities.
Thanks for your comments and my apologies if I don't seem to respond quickly, I haven't quite retired yet and work can get unpredictably busy!
~~waterdrop~~
My own inclination is to use some sort of input mask for data entry, a text field for table storage of 10 characters and then some sort of output masks when displaying this data in a form or report. I'm sure most of you have much more experience than me thinking about this. Perhaps integers would be better than text for the table storage. Perhaps you can tell me what terminology Access developers use for input masks and output masks and thus I could look up the correct reference pages for those activities.
Thanks for your comments and my apologies if I don't seem to respond quickly, I haven't quite retired yet and work can get unpredictably busy!
~~waterdrop~~