If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask
Hi Folks - Here's my problem. I have a table with a phone number field. Data
entry for this field was not controlled or validated. I have manually 'cleaned up' the mess. Now, I want to create an input mask that stores the literal values. I know how to create an input nask that stores the values, but here's the glitch .... The phone number for the exosting records displays properly, but it is not storing the literal values. It only stores the literal values for new records. Am I missing something, or do I have to update all the old records with parentheses, spaces and hypens? If so, can someone suggest the best method. Thanks!! Michael |
#2
|
|||
|
|||
On Sat, 4 Dec 2004 08:50:18 -0500, "Michael"
wrote: do I have to update all the old records with parentheses, spaces and hypens? If so, can someone suggest the best method. You do. The Input Mask has no effect on existing records. Run an Update query. If what's in there now is free of punctuation, e.g. 4445551234 you can run an Update query updating [Phone] to "(" & Left([Phone], 3) & ") " & Mid([Phone], 4, 3) & "-" & Right([Phone], 4) to get (444) 555-1234 John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Input Mask | Loi | New Users | 1 | November 18th, 2004 05:44 PM |
spaces input mask | Paul | Setting Up & Running Reports | 0 | November 8th, 2004 07:01 PM |
How to use a default value within an input mask | Kathy | Database Design | 1 | September 3rd, 2004 06:35 PM |
Input Mask not working ? | TonyB | Database Design | 4 | May 11th, 2004 11:26 PM |