Adjust field size of first name & last name on report

[ffleitas]

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?

 

[Sdaddy]

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.

 

[JeremyNYC]

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

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[BSman]

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