lose input mask

[Guest]

I have an input mask for telephone numbers and fax numbers. When I did a Union query some of the telephone numbers and fax numbers weren't in the format of the input mask. Some of them were still in the format, but some of them weren't. Why does it do this and how do I fix it

Thanks

 

[Van T. Dinh]

Suggest you check Access Help carefully the differences between Format
Property and InputMask Property. For InputMask Property, pay particular
attention to the option whether to save the mask in the Field values or not.

FWIW, you cannot enter / edit data in a Union Query so the InputMask doesn't
matter / apply in the Union Query since InputMask is only used when you
enter / edit data.

--
HTH
Van T. Dinh
MVP (Access)

I have an input mask for telephone numbers and fax numbers. When I did a

Union query some of the telephone numbers and fax numbers weren't in the
format of the input mask. Some of them were still in the format, but some of
them weren't. Why does it do this and how do I fix it?