Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adjust field size of first name & last name on report

Status
Not open for further replies.

ffleitas

Technical User
Mar 15, 2001
85
US
Hello programmers,

How do I adjust the field names [firstname] & [lastname] on the same line of a report to grow or shrink horizontally (not vertically in this case)? Also, if you can you do it for a [field] does it also apply for a label box?
 
I don't think you can make them grow horizontally. I would recommend just making your field box big enough that it won't cut off the longest name. This is just going to take a couple of test runs to make sure you have your boxes widened enough.

Also, you have to change the properties on each individual control or label.
 
Concatenate them either in the query or the control on the form as [firstname] & " " [lastname].

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Another trick for first and last name fields is to right justify the first name field (if you place it just to the left of the last name field) and left justify the last name field.

That way, instead of a display like this:

John Jones

You'll get:

John Jones
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top