txt box to include the info found in 3 other txt boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a report, how do I go about including the information of three different
txt boxes found on a query such as txtFirstName, txtMidInit, txtLastname all
into one txt box?
I dislike how it displays the name if I create 3 txt boxes to break up the
name, too many gaps, it looks ridiculos.
I tried modifying the txt box's control source using the expression builder,
this is what I did (but it did not work): =txtFirstName!txtMidInit!txtLastName
I think I am close, but I wouldn't be shocked if I was apporaching this the
wrong way.
Thanks
 
Use an expression like this as the control source of one textbox:

=[txtFirstName] & " " & [txtMidInit] & " " & [txtLastname]
 
Thank you Ken, it worked :)
Dax

Ken Snell said:
Use an expression like this as the control source of one textbox:

=[txtFirstName] & " " & [txtMidInit] & " " & [txtLastname]

--

Ken Snell
<MS ACCESS MVP>

Memphis said:
In a report, how do I go about including the information of three
different
txt boxes found on a query such as txtFirstName, txtMidInit, txtLastname
all
into one txt box?
I dislike how it displays the name if I create 3 txt boxes to break up the
name, too many gaps, it looks ridiculos.
I tried modifying the txt box's control source using the expression
builder,
this is what I did (but it did not work):
=txtFirstName!txtMidInit!txtLastName
I think I am close, but I wouldn't be shocked if I was apporaching this
the
wrong way.
Thanks
Click to expand...
Click to expand...
 
Back
Top