By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

Field Formatting Help

P: 1
I have searched the Word Help and the Access Help, I have consulted the well used Access Bible that sits behind my desk, and to no avail...so now I consult the mighty brain trust that is "thescripts". I have merged a query with a form in word, mail merge..very simple. However, my fields will not retain the formatting I have so painstakingly created in Access. I lose my dashes in the Social Security number and the medium date formatting in the dates. Though the dates are not too big an issue, the Social Security Number is. Can anyone help me with the field switches in the merge field. or give me a source that I can get a good field switch listing?

Thankx,
Sep 3 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

For the correct formating in your mail merge result, you have to work in Word! Word gets the data but concerning formatting of dates and numbers Word applies the settings that you have done for the specified fields!

When you use the command insert field in Word there is an option preserve formatting! Or you are using other commands to do your fields?

Or you are doing it by using the VB script editor and Html?

In this case it's better to convert your Dates and numbers in text before visualise them in form in word!

To set the needed length of your fields use the size property like this: <input type="text" name="p" id="p" size="20" /> And yours fields will be fit!
Sep 3 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
When you use an input mask in access it gives you the option to store the hyphens etc. with the data or not. Go to the table design view and go the the field that you need to change. Open the Input mask wizard
in the properties and follow through until you are given the option to save with or without mask. Save with mask.

Hi,

For the correct formating in your mail merge result, you have to work in Word! Word gets the data but concerning formatting of dates and numbers Word applies the settings that you have done for the specified fields!

When you use the command insert field in Word there is an option preserve formatting! Or you are using other commands to do your fields?

Or you are doing it by using the VB script editor and Html?

In this case it's better to convert your Dates and numbers in text before visualise them in form in word!

To set the needed length of your fields use the size property like this: <input type="text" name="p" id="p" size="20" /> And yours fields will be fit!
Sep 3 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.