473,406 Members | 2,217 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

How to create a report in letter format

Hi Guys,
I am new to access and I am trying to create a report in letter format so when I in the form I can select the hyperlink to open report and select which contacts I want to send this particular letter to using a filter. All seems to be going ok, however I cant sus out how to get it to reduce the size of Title and Surname fields so I dont get a huge gap between them IE)
Mr Bloggs
would like it to read
Mr Blogs

Would appreicate any help as simple at poss, as I am self taught on access and not use to all the terminology.
Thanks Guys

Tinks
May 5 '11 #1
1 2232
dsatino
393 256MB
I'm guessing you're referring to the length of them in which case you just need to use the trim() function on them.
May 5 '11 #2

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

Similar topics

2
by: Lee Falataco | last post by:
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar...
6
by: Helen | last post by:
Hi, I'm using VB .NET (Visual Studio 2002 Crystal Reports 9 (soon to upgrade to 10, just want 9 to work first Win 200 When I run the crystal report independently, I can access the Oracle 7.3.4...
2
by: John Young | last post by:
I am creating a report / letter that automatically fills in fields from a form when a command button is pressed on the form..... The idea is to create a report /letter containing member address and...
1
by: kylei | last post by:
I need to create a report for a monthly sales table that is sent to our company. Is there a way to create a report that will automatically sum totals from a file that is sent to us every month? ...
2
by: Jean-Claude Bertrand | last post by:
Hello to all .Net programmers! I am a consultant and I create very small application for small enterprise. Most of the time in my application, the number of users is under 5! I still program...
8
by: sesmap | last post by:
I have a table which is a list of clients that we are sending to another company to contact for updating their account. I have a second table that is the other company's report back to me telling...
1
by: tbehmand | last post by:
Hi I am getting the following message when I click on 'Create report in Design view', does anyone know how to fix this. "There was a problem retrieving printer information for this object. The...
0
by: raj3109 | last post by:
Hi experts, I’d like to have some helps from you guys. I need to create an app with C# and Crystal Report.Net using VS 2008 for a Landscape & Nursery company. The company will send out coupon...
6
by: and1 | last post by:
hello .. hmm currently i'm working on vba in excel, apparently i use ADO to extract a table data from access to excel and it works fine. the problem is when i use the extracted data to create a chart...
1
by: bullfrog83 | last post by:
I have a form that contains parameters for a report. After the user clicks Preview I have code that set's the Where clause for the report's record source. Once the report opens I close the parameter...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.