Input Mask Won't Carry Over

[Chris]

I am having trouble with my Access database. I have a
Mail Merge form I am filling out on Word, and I need to
have a phone number field. The problem is when I merge
the database and word file together the input mask I have
set up in Access doesn't seem to carry over. So my phone
number field ends up looking like 1234567890.

How can I fix this problem.

Thank you in advance for your help.

 

[John Nurick]

Hi Chris,

This is just one of the reasons many people feel input masks are more
trouble than they're worth. (Another is that if you ever have to input
an international phone number it won't display correctly.)

IMO the best thing to do is to store the number in the database (in a
text field, of course) complete with the spaces and parentheses and so
on. That way, Word will see what you see.

Otherwise, you need to use the Format() function in a calculated field
in a query; this will pass the formatted number to Word.

 

[Chris]

So, what is my best option for making sure my Word
document has the correct format? Can someone help me
with the code needed to set up a Format function?

Thank you

-----Original Message-----
Hi Chris,

This is just one of the reasons many people feel input masks are more
trouble than they're worth. (Another is that if you ever have to input
an international phone number it won't display correctly.)

IMO the best thing to do is to store the number in the database (in a
text field, of course) complete with the spaces and parentheses and so
on. That way, Word will see what you see.

Otherwise, you need to use the Format() function in a calculated field
in a query; this will pass the formatted number to Word.

I am having trouble with my Access database. I have a
Mail Merge form I am filling out on Word, and I need to
have a phone number field. The problem is when I merge
the database and word file together the input mask I have
set up in Access doesn't seem to carry over. So my phone
number field ends up looking like 1234567890.

How can I fix this problem.

Thank you in advance for your help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Like I said, use Format() in a calculated field in a query. It will look
something like this, where XXX is the name of the phone number field.

fPhone: Format([XXX], "(000) 000-0000")

depending on how phone numbers are formatted in whatever country you're
working in (it won't format international numbers correctly, of course).

So, what is my best option for making sure my Word
document has the correct format? Can someone help me
with the code needed to set up a Format function?

Thank you

-----Original Message-----
Hi Chris,

This is just one of the reasons many people feel input masks are more
trouble than they're worth. (Another is that if you ever have to input
an international phone number it won't display correctly.)

IMO the best thing to do is to store the number in the database (in a
text field, of course) complete with the spaces and parentheses and so
on. That way, Word will see what you see.

Otherwise, you need to use the Format() function in a calculated field
in a query; this will pass the formatted number to Word.

I am having trouble with my Access database. I have a
Mail Merge form I am filling out on Word, and I need to
have a phone number field. The problem is when I merge
the database and word file together the input mask I have
set up in Access doesn't seem to carry over. So my phone
number field ends up looking like 1234567890.

How can I fix this problem.

Thank you in advance for your help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.