losing input masks

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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 masks 1
input mask formatting is lost when tables are formed to a union qu 2
Input masks 4
Access - Input Mask 2
Access Input Mask for phone number 2
Input Mask 1
lose input mask 1

Back
Top