Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-29-2005, 05:54 AM   #1
PaulT
Registered User
 
Join Date: Feb 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
PaulT is on a distinguished road
Big ugly gaps in my reports??

I have created some reports which include using people's first names and their surnames which I have in a table as separate entities.

But when it comes to producing the reports there are big gaps after some of the surnames because people's surnames are of different lengths obviously.

e.g
"John Smith"
as opposed to
"Christopher Smith"

Is there a way that the Access adjusts the size of the text boxes to fit the names alongside each other normally on the Report so that the gaps do not appear?

Thanks for your help (and please don't suggest shorting the name to Chris for example instead of Christopher!!).

Paul

PaulT is offline   Reply With Quote
Old 03-29-2005, 06:00 AM   #2
KenHigg
Registered User
 
Join Date: Jun 2004
Posts: 13,309
Thanks: 8
Thanked 155 Times in 129 Posts
KenHigg has a spectacular aura about KenHigg has a spectacular aura about
You could try to concatenate them in the underlying query.

Ken
KenHigg is offline   Reply With Quote
Old 03-29-2005, 06:06 AM   #3
PaulT
Registered User
 
Join Date: Feb 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
PaulT is on a distinguished road
Ok thanks Ken!

Emmmmmm, how exactly do I concatenate them?

PaulT is offline   Reply With Quote
Old 03-29-2005, 06:14 AM   #4
trucktime
Registered User
 
Join Date: Oct 2004
Location: Arizona
Posts: 556
Thanks: 0
Thanked 2 Times in 1 Post
trucktime is on a distinguished road
Concatenate

Ad a column to the query and in the Field row put something like:

TotalName: [Firstname] & " " & [Surname]

Then in the report the fieldname you will use is: TotalName
__________________
Trucktime
trucktime is offline   Reply With Quote
Old 03-29-2005, 06:20 AM   #5
KenHigg
Registered User
 
Join Date: Jun 2004
Posts: 13,309
Thanks: 8
Thanked 155 Times in 129 Posts
KenHigg has a spectacular aura about KenHigg has a spectacular aura about
There are a couple ways actually. To concat, or combine the, simply do something like the following in the query on the top line of a blank col:

FullName: fname & " " & lname

Or you could just do this in the report's textbox:

=[fname] & " " & [lname]

Does this help (Somtimes these things are hard to explain )

Ken
KenHigg is offline   Reply With Quote
Old 03-29-2005, 06:43 AM   #6
PaulT
Registered User
 
Join Date: Feb 2005
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
PaulT is on a distinguished road
Thanks very much to both of you!!! That has worked perfectly!!!

Many thanks again!

PaulT is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 02:47 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World