how do I write an expression to concatenate text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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
--

hails said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top