concatenate records

[jpr]

hello,

I have a form with four fields: Fname, Lname, DOB and txtresult.

Examples: JOHN, SMITH, 03/19/2006.

The first three are bound to a table while the txtresult is unbound.

I would like to associate a code that returns to the txtresult the
following information:

txtresult=

JOHN SMITH was born on 03/19/2006.

Is there a way to do this and where to add the code? Basically I need
to concatenate several records in one field and add some text between
them.

Thank you.

[Allen Browne]

Remove txtResult from the table.

Instead, create a query, and type this into a fresh column in the Field row:
Result: [Fname] & " " & [Lname] & " was born on " & [DOB] & "."

More info in:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jpr" <jp***@tin.it> wrote in message
news:11*********************@z34g2000cwc.googlegro ups.com...

hello,

I have a form with four fields: Fname, Lname, DOB and txtresult.

Examples: JOHN, SMITH, 03/19/2006.

The first three are bound to a table while the txtresult is unbound.

I would like to associate a code that returns to the txtresult the
following information:

txtresult=

JOHN SMITH was born on 03/19/2006.

Is there a way to do this and where to add the code? Basically I need
to concatenate several records in one field and add some text between
them.

Thank you.

[jpr]

thanks for you reply. Unfortunately I don't want to create another
query since my form is based on a query and I need to txtresult as it
can be used by users to add any other data they want .

My idea was to allow users to save time in having to write into the
the unbound text box.

Is there a way I can do it simply by code?

[salad]

jpr wrote:

thanks for you reply. Unfortunately I don't want to create another
query since my form is based on a query and I need to txtresult as it
can be used by users to add any other data they want .

My idea was to allow users to save time in having to write into the
the unbound text box.

Is there a way I can do it simply by code?

You were close in your first post. You wrote
txtresult=JOHN SMITH was born on 03/19/2006

Why not put in the ControlSource of txtresult
=[FirstName] & " " & [Lastname] & " was born on " & [BirthDate]

That would be similar to making a hard coded field as the control source
="JOHN SMITH was born on 03/19/2006"

[Allen Browne]

If you are saying that you want the text field to default to that value, but
users can change it, you could use the AfterUpdate event of the 3 fields to
assign the text to the result field.

The article I pointed you to explains when and how to do that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jpr" <jp***@tin.it> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...

thanks for you reply. Unfortunately I don't want to create another
query since my form is based on a query and I need to txtresult as it
can be used by users to add any other data they want .

My idea was to allow users to save time in having to write into the
the unbound text box.

Is there a way I can do it simply by code?