Input mask does not work in report based on query.

[pdgnw]

All my phone numbers have input masks.&nbsp;&nbsp;They work fine; however, now I am doing a report based on a query and the input mask is not working.<br><br>Note:&nbsp;&nbsp;I did convert from Access 97 to Access 2000.&nbsp;&nbsp;The tables were created in Access 97.&nbsp;&nbsp;Could this be the problem?

 

[Garridon]

Did you put an input mask on the field in the report?

 

[pdgnw]

Thanks for the reply! Actually I have a query in which the Design View is apparently unavailable. It is a Union query as opposed to a Select query. With my select queries I can access Design View and from there I can go into Field Properties and do an input mask; but where do I do this with a union query (if at all?) Thanks again.

 

[DreewToo]

I usually construct a union query as it's individual groupings in separate Select queries, and when I'm sure they are behaving, put them together. It seems the easiest to maintain (having encountered a 20+ field 6+ join union query recently). I'd be happy to know of an easier way.

Using Format(strX, &quot;(@@@) @@@-@@@@&quot should work. Reports I don't think work with input masks, I believe the format property of the report would do the trick though.

hth,
Drew

 

[rafe]

of course, you could always put the format statement in the &quot;Record Source&quot; property of the phone# field of the report if you don't want to do it &quot;free style&quot; in the union query.

i use this method with the iif() function to do alternate formatting for things like social security# vs. entity ID# etc. something like

=IIf([Vendor],Format([PayeeID],&quot;00 0000000&quot,Format([PayeeID],&quot;000 00 0000&quot)

hope this helps

rafe