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.
 
Back
Top