Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combining Fields In Access
- Thread starter FontanaS
- Start date
My suspicion is that they hyphens are actual text that has been entered, yes?
If so, open the table, delete all of the hyphens by Find hypen, Replace with nothing.
Then, in design of your table, for that field, use a format like ###-###-#### and your numbers should be able to be entered as 1234567890, but will display as 123-456-7890. Then, when you do other things with those values, they won't have the hyphens in them.
Not sure of the exact formats...
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
If so, open the table, delete all of the hyphens by Find hypen, Replace with nothing.
Then, in design of your table, for that field, use a format like ###-###-#### and your numbers should be able to be entered as 1234567890, but will display as 123-456-7890. Then, when you do other things with those values, they won't have the hyphens in them.
Not sure of the exact formats...
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
- Status
Similar threads
