losing input masks

G

Guest

I have an input mask for the phone number and fax number. Why is it that when I make a union query that some of the phone numbers and fax numbers are no longer in the input mask?
 
J

John Vinson

I have an input mask for the phone number and fax number. Why is it that when I make a union query that some of the phone numbers and fax numbers are no longer in the input mask?
Click to expand...

Both Format and Mask properties are local to the table. UNION, export,
etc. will usually discard them. You can use the Format() function to
recast the field into the desired appearance as a calculated field.
 

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

Similar Threads

Remove input mask format 4
input mask formatting is lost when tables are formed to a union qu 2
Access - Input Mask 2
Input masks 4
Input masks 1
Input Mask 1
Formatting issue with imported telephone number! 2
updating existing records to match input mask format 11

Top