Input Mask not working

[Kat]

I have a database that is used for a fax list for our company listing all of
our customers. It's worked great for several years. Recently my machine
which is a shared server crashed and I had to reformat the machine (XP Pro)
and I use Office 2000. I got the database back from a backup file and it
was working fine. Recently I went into the database to make some changes on
phone numbers from companies that have either moved or changed their names.
When I was ready to print, I noticed some of the fields are not showing a
phone number format (000) 000-0000 There are several fields used to pull
the fax numbers and most show up just fine, just one field is just showing a
ten digit number without the format 0000000000.

I've checked the database to make sure the "table" has the right input mask,
fax1no shows !\(999") "000\-0000;0;_ as does fax2no, fax3no etc. so why on
my report do i get the number showing as (000) 555-5555 in some of the fax
fields and not in others. Any suggestions on how to fix this?

Thanks in Advance

Kat

 

[Brian Bastl]

The input mask for the field in the table is unnecessary IMO, since you/
your users should adding/ editing/ viewing records via forms and reports.

Brian

 

[Kat]

That is the problem, when I print out the report fax numbers show correctly
for some of the fields but one just shows up as 0000000000 while others will
have correct formatting of (000) 000-0000 When inputting the numbers it's
formatted correctly, when I right click on the field while the report is in
edit mode it shows correctly but when I print preview, it just shows a 10
digit number

Kat

 

[Kat]

Incase anyone was wondering, I fixed my problem. I don't know why it was
doing as it was but after putting in a Input Mask in every place I possibly
could (forms, reports, database) my fax numbers were still showing
incorrectly. I even recreated the report only to experience the same
problem. When I finally went into the form and re-entered the fax number
into the field again, closed the form and then viewed the report, the number
showed correctly. Unfortunately I had to go back and re-enter every fax
number that was showing without the correct formatting on the report. After
re-enter more than I care to count for some reason they show correctly now.
I don't know if there is a weird cache somewhere in Access that was doing
that but it's fixed.

Thanks anyways
Kat