Text box with two fields concatenated together 1

[bernie10]

Hello all,
Suppose I have a form that is tied to a query called "products". I would like to tie two fields from the query together in a single text box seperated by a ";".

So if my query entrees are as follows:

Product Color Size
1 Blue Large
2 Red Small

The text box would show:
Blue; Large
Red; Small

as I scroll to the particular records. What do I put in the control source field of the text box to get the text box to display this data?

Thanks,
Collen

 

[Minkers]

This isn't quite as simple as putting something in the control. You would need to code the way it works. Create an unbound text box. In the Curren event of your form, put the code:

Me.unboundcontrol.value= color & size

This is a very rough idea how to do this, but it should get you what you need.

HTH,
Mink

 

[traingamer]

Set control sdource to:

=[color] & ";" & [size]

traingamer

 

[bernie10]

Thanks for both of your replies.

Traingaimer's solution easily did the trick.