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.
Quote:
Originally Posted by 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!
