#error on one field when concatenating fields

  • Thread starter Thread starter Bruce Musgrove
  • Start date Start date
B

Bruce Musgrove

I have several text fields on a table I want to concatenate into one on a
form. All text fields have identical properties, and are 50 characters in
length.
Application
Version
License number

If I use a wizard and create seperate fields, all fields work fine. If I
create a empty text box and use the expression builder to concatenate the
fields for the control source , it always fails with "#error" The string I
use for control source is "=[Application] & [Version] & [LicenseNumber]"

I have narrowed it down to the "[Application]" portion. Everything works
fine until I add the "=[Application]" field to the string. It even fails if
use "=[Application]" by itself . Take it out and it all works great. Put
it in and it fails.

I have compacte and repaired the database to no avail. I have noted I can
concatenate these in a query nd have it work. I would like to discover why I
can't do it directly in the form / report .
 
I have several text fields on a table I want to concatenate into one on a
form. All text fields have identical properties, and are 50 characters in
length.
Application
Version
License number

If I use a wizard and create seperate fields, all fields work fine. If I
create a empty text box and use the expression builder to concatenate the
fields for the control source , it always fails with "#error" The string I
use for control source is "=[Application] & [Version] & [LicenseNumber]"

I have narrowed it down to the "[Application]" portion. Everything works
fine until I add the "=[Application]" field to the string. It even fails if
use "=[Application]" by itself . Take it out and it all works great. Put
it in and it fails.

I have compacte and repaired the database to no avail. I have noted I can
concatenate these in a query nd have it work. I would like to discover why I
can't do it directly in the form / report .
Click to expand...

is the name of the control Application? if yes then change it to
txtApplication

BTW: don't use this name; Access has an object application, this can
be also troublesome
 
Okay, that was simple. I should have realized that one, but it is always
something simple! Thank you


Andi Mayer said:
I have several text fields on a table I want to concatenate into one on a
form. All text fields have identical properties, and are 50 characters in
length.
Application
Version
License number

If I use a wizard and create seperate fields, all fields work fine. If I
create a empty text box and use the expression builder to concatenate the
fields for the control source , it always fails with "#error" The string
I
use for control source is "=[Application] & [Version] & [LicenseNumber]"

I have narrowed it down to the "[Application]" portion. Everything works
fine until I add the "=[Application]" field to the string. It even fails
if
use "=[Application]" by itself . Take it out and it all works great. Put
it in and it fails.

I have compacte and repaired the database to no avail. I have noted I can
concatenate these in a query nd have it work. I would like to discover why
I
can't do it directly in the form / report .
Click to expand...

is the name of the control Application? if yes then change it to
txtApplication

BTW: don't use this name; Access has an object application, this can
be also troublesome
Click to expand...
 
Back
Top