How do I insert Parentheses automatically into a field in Access?

[SonnyBobSue]

I asked this question earlier but when the answe came to my e-mail and I
tried to open the link I got nothing but a blank page.
I want to know if it is possible to automatically put parentheses around the
text entered in a particular field with out actually typing the parentheses
every time - some way to set up the format of that field.

 

[Jeanette Cunningham]

Bad luck that the link to these answers was not in the email.
You have 3 answers already. They do not involve setting up a format, but
every time the user finishes typing in that textbox, the parentheses will be
put around the text automatically.
I don't know of any format that will put the parentheses there, but there
can be problems where setting a format in the table can mess up something
else in the database. It is safer to go with the suggestions you have been
given.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia