B Love wrote:
Hello Group,
I have 2 text fields that I would like to concatenate for use in a table.
One field is an ordinary text box. The other is a simple combo box which I
use to select one of about ten items.
The ordinary text field is: NewLongDescription
(This is a memo field that contains descriptions of dolls sold in an e-comm
site)
The combobox is: Default Hair Color
It gets information from a table called: DefaultHairColorTable
(this table contains various hair colors for dolls)
I thought I could just type the following in the LongDescription text box in
the design view:
LongDescription=[NewLongDescription]&" "&"Stock Hair Color (if any):"&"
"&[Default Hair Color]
but the form displays: #Name?
What am I missing?
I hope you can help shed some light on what i am doing wrong.
Thanks
~Bruce
Buce;
As control source in an UNBOUND control:
=[NewLongDescription] & " " & "Stock Hair Color (if any): " & [Default
Hair Color]
NOT..
LongDescription = [NewLongDescription] etc.
Notice I've also simply added the space after "(if any): "
to avoid the extra & " " & you have used.
Make sure the name of the control is not the same as the name of any
field used in it's control source expression. If you use an unbound
control (as I have suggested above) whenever you use an expression you
will not have any problem.
If you convert the control source of a bound control, and neglect to
change the control name, you will get an error,)
I don't know what you mean when you say you want to 'concatenate for use
in a table.'
Calculated data, (meaning concatenated in this instance) should NOT be
saved in any table. Whenever you need the concatenated text, just
re-concatenate it, in a form, a query, or in a report, as above.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.