S
Sara M
I have a client directory report that is based off of a
query. The original table has input masks incorporated
for all phone numbers. In the report, some phone numbers
show up with the input mask, like I want them too, but
some don't. The expression I have written is
=IIf(IsNull([Fax]),"","Fax: " & [Fax]).
I have copied this expression for the additional phone
fields to be displayed in the report.
=IIf(IsNull([General Phone]),"","General Phone: " &
[General Phone])
The problem is out of the 8 phone number options only 2 of
them are showing up with the desired input mask. The rest
do not have the desired format, all the numbers are ran
together (999999999) rather than appearing as (999) 999-
9999. I know that a formatting issues can over ride input
masks. However when comparing the working expression, to
those that don't work, I can't seem to see what the
problem would be. Seems to me it should be something
really simple, but I've tried to figure it out for so
long, I'm extremely frustrated, please help. PS. The
input mask created in the table appears as !\(999") "000\-
0000;0;_ Don't know if that helps. Thanks.
query. The original table has input masks incorporated
for all phone numbers. In the report, some phone numbers
show up with the input mask, like I want them too, but
some don't. The expression I have written is
=IIf(IsNull([Fax]),"","Fax: " & [Fax]).
I have copied this expression for the additional phone
fields to be displayed in the report.
=IIf(IsNull([General Phone]),"","General Phone: " &
[General Phone])
The problem is out of the 8 phone number options only 2 of
them are showing up with the desired input mask. The rest
do not have the desired format, all the numbers are ran
together (999999999) rather than appearing as (999) 999-
9999. I know that a formatting issues can over ride input
masks. However when comparing the working expression, to
those that don't work, I can't seem to see what the
problem would be. Seems to me it should be something
really simple, but I've tried to figure it out for so
long, I'm extremely frustrated, please help. PS. The
input mask created in the table appears as !\(999") "000\-
0000;0;_ Don't know if that helps. Thanks.