>I think I may have lost my mind or something. Im trying to set up formats to input the phone number and when I do this, I get my dashes and everything in the text box, but the data in the field is stored with out the dashes, how do I get the dashes to also store in the table. I can put the dashes in the table buy hand, then when the data is displayed on my form, I have 2 dashes next to each other and my phone number doesnt look right. I dont want the input clerks to key in the dashes, but I also want the dashes to show up in the tables. any help?
>
>Thanks
>Ron
Basically, it's about Control.Format="R". Use it if you want to remove dashes from data, and do not use it you want to keep them. Normal practice is to remove.
Edward Pikman
Independent Consultant