Re: txt box to include the info found in 3 other txt boxes
- From: "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 9 Aug 2005 15:41:34 -0400
Use an expression like this as the control source of one textbox:
=[txtFirstName] & " " & [txtMidInit] & " " & [txtLastname]
--
Ken Snell
<MS ACCESS MVP>
"Memphis" <memphisland@xxxxxxxxxxxxxxxx> wrote in message
news:559F1C71-32A8-4BFA-8DB5-4BFF7D2887DF@xxxxxxxxxxxxxxxx
> 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
>
.
- Follow-Ups:
- References:
- txt box to include the info found in 3 other txt boxes
- From: Memphis
- txt box to include the info found in 3 other txt boxes
- Prev by Date: Re: Getting a Negative Value in a Sum
- Next by Date: Re: accumulated hours
- Previous by thread: txt box to include the info found in 3 other txt boxes
- Next by thread: Re: txt box to include the info found in 3 other txt boxes
- Index(es):
Relevant Pages
|
