form bound to query, display concatenated fields

  • Thread starter Thread starter Ketaki
  • Start date Start date
K

Ketaki

Hi,

I have an MS Access form bound to a query. in a text box i
want to display concatenation of 2 fields from that query.
it is giving me a #Name? error but can display individual
fields by themselves. I tried both & and + signs, but does
not help.

Thanks,
Ketaki
 
Ketaki said:
Hi,

I have an MS Access form bound to a query. in a text box i
want to display concatenation of 2 fields from that query.
it is giving me a #Name? error but can display individual
fields by themselves. I tried both & and + signs, but does
not help.
Click to expand...

If your text box started life as a control bound to one of the fields,
it may have the same name as the field. Change its name to something
else that is not the name of any field in the form's recordsource.
 
Back
Top