In the Access database types of text data in a table of fields, field in the format of the attribute input & gt;" Tel_ "(& amp; & & amp;) @ @ @ @ @ @ @ @, enter 02787654321, will show (), enter 027, will show (), input the ABC, will show () (space substitute "~")