Report field spacing question 2

[mman74]

I have a report displaying fields such as First Name and Last Name. When I create my report I have to lay out the space to print First Name and then Last Name. If a person's first name is particularly short, his first name becomes quite distanced from his last name. Is there a way to make the width of the first name variable according to the length of the data in that record so that I can overcome this problem?
Thank you.

 

[WildHare]

Create a new text variable and set it to this:

me!FirstName & " " & Me!LastName

The & concatenation operator will shove both parts together, stripping off the trailing blanks from FirstName (which, actually, shouldn't be there in the first place) and then wedge one space between that and the LastName string.

Use this SINGLE column guy instead of two columns for First and Last.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[Celeste025]

You can merge the fields. First create an unbound text box (the button looks like ab|). Then in the control source property for that text box, type something like this:

=[First Name] & " " & [Last Name]

Where the text inside the brackets are your actual field names.

 

[mman74]

Thank you very much Wildhare & Celeste025!