input mask formatting is lost when tables are formed to a union qu

[Susan]

I have set an input mask for the fax number text fields of 2 similar tables.
When the tables are joined to form a union query, the formatting is not
accurate. Some fax numbers contain the proper formatting of (123) 456-789
while others read 123456789. What could be causing this to happen?

 

[Jeanette Cunningham]

Susan,
I just tried a union query with 2 different tables where both had fax
numbers formatted as (123) 456-789. The resulting query had all the fax
numbers formatted as (123) 456-789, - I couldn't reproduce your problem with
my simple tables. Please post the SQL of your union query and we might be
able to help.


Jeanette Cunningham

 

[Jeanette Cunningham]

Susan,
Was able to reproduce your problem by putting some fax numbers in the table
without using an imput mask. When I opened the table, you could see that the
input mask hadn't been used becuase I had entered the numbers like:
221547894.
Then when I ran the union query, most of the fax nos looked like (221) 547
894, but the ones put in without using the input mask looked like 221547894.

Jeanette Cunningham