Automatically taking contents from one field and put it into anoth

[Guest]

How can i make it that lets say i fill out a few difrennt fields and it well
then place the contents of at least two of those field into a third field
combined (i nead it to be this way. not that will print out the results into
a third pacerather it will store it into another field in the table.

For example:

Field A "Mr."
Field B "John"
Field C "Smith"


And it will automatically place in in Field D (which should i guess be a
plain text box):
"Mr. John Smith" Basically "Field A Field B Field C"

Thank you

 

[Wayne Morgan]

First, I recommend that you DON'T store it that way. Save it as the separate
fields. You can combine them for display purposes, such as for a report,
whenever you need to. To do so, you would use a calculated textbox. Set its
Control Source to an equation that will concatenate the three fields.

Example:
=[Field A] & " " & [Field B] & " " & [Field C]