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,
2 2401 PEB 1,418
Recognized Expert Top Contributor
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!
MMcCarthy 14,534
Recognized Expert Moderator MVP
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!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: PMB |
last post by:
Thank you in advance for any and all assistance.
I'm trying to input data from strings to a memo field. I would like to know
how to check first to see if there is text there currently and if so move to
the end and input the new text.
Also, would like to know if I can change the justification on each line of
text as it's entered. i.e.
Company Name, address, city state and zip would be centered and all the
|
by: GorDon |
last post by:
Hi,
I have a report based on a query. The query grabs a memo field from
my main table, yet when I display the memo field in the report it
truncates the memo field (the field needs to hold more than 255
characters). The table holds all the memo text, but the query seems
to truncate the memo field to 255 chars?
This seems like there should be a relatively easy fix, but I can't
seem to find it.
|
by: HardBap |
last post by:
I have an Access database that has an input mask on a field, !\(999")
"000\-0000;0;_ , that formats a phone number. When I fill a DataSet
using an OldDbDataAdapter some of the records lose the formatting. For
example:
Sam Jones (999) 555-1212 *this is good*
Joe Smith 9995551212 *this is bad*
Why would some records lose the formatting? There is no ryme or reason
(that I can see anyway) why some records keep the formatting and some
|
by: Don Do |
last post by:
Help
I built a form/subform/subsubform setup using the access forms
wizard. I have a table1 = parent, table2 = child, table3 =
(grandchild?). There will be multiple records in table2 that tie to
table1, and multiple records in table 3 that tie to table2. Both on
"1 to many" joins.
Each of the forms are bound to the fields in the respective tables.
The subform & subsubform are datasheet view. When I enter any data, I
|
by: rlntemp-gns |
last post by:
Re: Access 2003/Word 2003
I have about 100 motivational documents that I am wanting to import
into a small database and put a front end on it that would allow the
user to select one, read it and print it.
Some of these original documents have bold formatting, a picture, and
some italics.
To try and preserve the original formatting would it be better to
reference the actual Word document object on the hard drive and
| |
by: Katherine |
last post by:
I'm trying to filter the records on the mainform (MailingList) of my
database using a field contained in a subform (Donations). I was
basing my code off Allen Browne's Access Tips page (here:
http://allenbrowne.com/ser-28.html) since it has worked so well in the
past. However, now I'm trying to filter by date instead of by a
string or a number, and I'm getting nowhere. My goal is to have users
type a date into the unbound combo box and...
|
by: myemail.an |
last post by:
If I need to format how the content of a field is displayed, I can
click ALT + ENTER from design view, and specify the format, for
example, the number of decimal digits and so on.
Is there a way to apply the same kind of formatting to more than one
field at the same time? I tried selecting multiple fields, but if then
I click ALT + ENTER I don't have the option to choose formatting.
Also, how can I format dates as dates? I have a table...
|
by: DeanL |
last post by:
Hi guys,
I'm using a subform to display a list of values from a single table.
The form is showing the values in "continuous forms" view and there
will only ever be two different values for the form. The form show 2
fields, 1 is a number and the second is a calculated field that says
either "Valid" or "Invalid" based on the first fields contents. What
I need to do is if the value is Invalid then I'd either like the text
or the actual...
|
by: Greg (codepug |
last post by:
Access 2000
Using a textbox of a single form, I created a calculated field. The
following code is in the Control Source for this field:
=IIf(=24,+(/),/
)
The numbers that are calculated are correct, and is working fine.
Using Conditional Formatting for this textbox, I attempt to change the
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |