combining fields and other stuff

  • Thread starter Thread starter Striker
  • Start date Start date
S

Striker

I have a field I would like to out on a form that combines some data from
fields in the database with some other stuff. AS an example let's say I have
a Critters Table with a Animal field. The animal filed has a value "Brown
Fox" in it.

I want A field that adds the words A Quick Brown Fox runs fast. The Brown
Fox is the only information I am storing in a table, so how do I join this
info on one text field on a form?
 
Assuming your form is bound to the Critters table, you can set the
ControlSource of the text box to

="A Quick " & [Animal] & " runs fast"

Include the equal sign.
 
Back
Top