Input Mask not working

  • Thread starter Thread starter Kat
  • Start date Start date
K

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