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

S

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?
 
J

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top