|
View Full Version : Input Mask superrob5 06-26-2003, 01:15 PM I want to be able to enter either 516-222-1111,____ ___-___-1111,____ 516-222-1111,3333 as the input mask for phone numbers what would be the format???? I tried a couple different ways but its not working Fizzio 06-26-2003, 01:24 PM either 999-999-9999,9999;0;"_" if no characters are mandatory 999-999-0000,9999;0;"_" if the 3rd set of nos are required. hth superrob5 06-26-2003, 02:02 PM kool thanks is it the same way if I want 2 have 2 dates in a field I will try it when I get home but was getting errors. Fizzio 06-26-2003, 02:14 PM Why do you want to have 2 dates in a field - not a good idea. Store the 2 dates in separate fields. superrob5 06-26-2003, 04:37 PM this is becasue based on someones excel spreadsheet and they want this, I might do it the other way but how do I do this?? Fizzio 06-27-2003, 12:41 AM If you are importing from an excel spreadsheet, this will be a little more tricky but if you are inputting the data, just set up a field for each date. Db fields are designed to store 1 piece of information and 2 dates is strictly classed as 2 separate pieces of info. If you ever need to do analysis on these dates, it will be nigh impossible if they are both in the one field. |