|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 12th, 2007, 07:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Show Multiple fields in 1 text box?
Hi
I have done this befor but cannot remember how to do it. I have 2 fields [FirstName] and [LastName] How do I show both fields in 1 TextBox? Kind Regards John 
|
|
#2
July 12th, 2007, 08:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show Multiple fields in 1 text box?
Base your form or report on a query and put the following expression in a
blank field: FullName:[FirstName] & " " & [LastName] On your form or report set the cpntrol source property of the tectbox to FullName. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "John" wrote in message ... Hi I have done this befor but cannot remember how to do it. I have 2 fields [FirstName] and [LastName] How do I show both fields in 1 TextBox? Kind Regards John
|
|
#3
July 12th, 2007, 08:32 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show Multiple fields in 1 text box?
[FirstName] & " " & [LastName]
-- KARL DEWEY Build a little - Test a little "John" wrote: Hi I have done this befor but cannot remember how to do it. I have 2 fields [FirstName] and [LastName] How do I show both fields in 1 TextBox? Kind Regards John
|
|
#4
July 12th, 2007, 08:48 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show Multiple fields in 1 text box?
On Thu, 12 Jul 2007 19:50:46 +0100, John wrote:
Hi I have done this befor but cannot remember how to do it. I have 2 fields [FirstName] and [LastName] How do I show both fields in 1 TextBox? Kind Regards John In your report, add an unbound text control. Set it's control source to: =[FirstName] & " " & [LastName] -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#5
July 12th, 2007, 09:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Show Multiple fields in 1 text box?
Thanks Guys,
Regards John "John" wrote in message ... Hi I have done this befor but cannot remember how to do it. I have 2 fields [FirstName] and [LastName] How do I show both fields in 1 TextBox? Kind Regards John
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
