how do I write an expression to concatenate text

[hails]

I need to concantenate text in a form control. I select the table and the
fields but I get the error #name? I need to know what coding to use so I
dont get this error.
There are many tables and forms to choose from in the expression builder.

 

[Duane Hookom]

This is usually caused by the control name being the same as a field name in
your report's record source.

Since you didn't provide your control's name or control source, we can't
provide much more assistance.

 

[hails]

ok sure

The control is called id - i want it to be a concatenation of two fields of
a table

the table is called trial_tbl, the fields are called Trial_ID and Brief_title

so I tried this expression

=[trial_tbl]![Trial_ID] & "" & [trial_tbl]![Brief_title]


but it is no go

 

[Duane Hookom]

There is generally no good reason to include the table names in these
expressions. Do the table names show in the Field List? Also, there isn't a
need to concatenate in the zero-length-string.

=[Trial_ID] & [Brief_title]

--
Duane Hookom
MS Access MVP
--

ok sure

The control is called id - i want it to be a concatenation of two fields
of
a table

the table is called trial_tbl, the fields are called Trial_ID and
Brief_title

so I tried this expression

=[trial_tbl]![Trial_ID] & "" & [trial_tbl]![Brief_title]


but it is no go

This is usually caused by the control name being the same as a field name
in
your report's record source.

Since you didn't provide your control's name or control source, we can't
provide much more assistance.