Concatenating a value from a list box

[bruce.musgrove]

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........

 

[Marshall Barton]

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........

Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).

 

[Blackhole]

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........

Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).

The concatenated text box is actually called "text14" Or are you referring
to the table field [applications]?

Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.

 

[Blackhole]

Never Mind. I see. I need to rename it in the source table

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........

Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).

The concatenated text box is actually called "text14" Or are you referring
to the table field [applications]?

Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.

 

[Marshall Barton]

Never Mind. I see. I need to rename it in the source table

"Marshall Barton" wrote

[email protected] wrote:

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........


Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).

The concatenated text box is actually called "text14" Or are you referring
to the table field [applications]?

Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.

Sorry, the most common reason for that error is that the
text box and the field have the same name. You should not
need to change the name of a field in a table.

If Application is the name of a field in the table, then
double check that you do not have a control anywhere in the
report with that name.

If I have misunderstood again, please try to clarify what is
where. The use of a lookup field in your table may (or may
not) be a big part of the confusion because what you see is
not necessarily what you get with those things.

 

[Blackhole]

Never Mind. I see. I need to rename it in the source table

"Marshall Barton" wrote
[email protected] wrote:

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........


Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).


The concatenated text box is actually called "text14" Or are you
referring
to the table field [applications]?

Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.

Sorry, the most common reason for that error is that the
text box and the field have the same name. You should not
need to change the name of a field in a table.

Okay. I thought I checked for that, but I have missed simpler things. I wil
look again. The fact that it worked when I changed the name in the source
table should be an indicator I probably overlooked soemthing.

If Application is the name of a field in the table, then
double check that you do not have a control anywhere in the
report with that name.

If I have misunderstood again, please try to clarify what is
where. The use of a lookup field in your table may (or may
not) be a big part of the confusion because what you see is
not necessarily what you get with those things.

Agreed. This was a quick and dirty database to track my computer inventory
and I did not have enoug time to do proper lookups using forms or queries.
It was easier to build it into the table at the time.

 

[Marshall Barton]

"Marshall Barton" wrote

Never Mind. I see. I need to rename it in the source table



"Marshall Barton" wrote
[email protected] wrote:

Trying to create a concatenated text box value on a report. The
control source is

="Applications:" & [Application]

[Application] is a drop down list box. The source of the report is
directly from a table.


I always get a #error# for the result. This works fine on a regular
text field from the table (non drop down list box), so I know there is
something stupid I am missing.........


Change the name of the text box to someting other than
Application (the usual naming convention would be
txtApplication).


The concatenated text box is actually called "text14" Or are you
referring
to the table field [applications]?

Example of what I want the field to say:
"Applications: WinDVD" where the WINDVD would be what is pulled from the
drop down field [application] and "applications:" is the plain text
concatenated to the front of it.

Sorry, the most common reason for that error is that the
text box and the field have the same name. You should not
need to change the name of a field in a table.

Okay. I thought I checked for that, but I have missed simpler things. I wil
look again. The fact that it worked when I changed the name in the source
table should be an indicator I probably overlooked soemthing.

If Application is the name of a field in the table, then
double check that you do not have a control anywhere in the
report with that name.

If I have misunderstood again, please try to clarify what is
where. The use of a lookup field in your table may (or may
not) be a big part of the confusion because what you see is
not necessarily what you get with those things.

Agreed. This was a quick and dirty database to track my computer inventory
and I did not have enoug time to do proper lookups using forms or queries.
It was easier to build it into the table at the time.

Since it works when you cahnge the name in the table, I am
now wondering if the fact that Application is a reserved
word could have something to do with the problem. Changing
the field name is probably a good idea in any case.

Quick and dirty always causes more work in the end ;-)

 

[Blackhole]

Snip

Since it works when you cahnge the name in the table, I am
now wondering if the fact that Application is a reserved
word could have something to do with the problem. Changing
the field name is probably a good idea in any case.

Quick and dirty always causes more work in the end ;-)

Yes it Did. I had a couple of those like "application" and "type" I went
through all the tables, forms and reports, changed the names, searched a
lot of code, changed that, and it works fine. I had been needing to do
that for awhile and just did not connect the two.

Thanks for the tip!