One field displays blank for one record on report

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

Guest

I have a report in an Access 2002 database in which one field for one record
displays blank. The Control Source for the field on the report is an
expression containing a concatenation of several of the fields from a table.
There is data in the fields for this record in the table. All the other
records display just fine. Any ideas why there would be difficulty with just
one record? Thanks.
 
Do all of the fields contain a value? Can you share your expression? Did you
concatenate with "&" or "+"?
 
Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others display just
find. Strange.

Thanks for you help.
 
Have you looked at the record in the datasheet view of the report's record
source?

--
Duane Hookom
MS Access MVP


felicitea said:
Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others display
just
find. Strange.

Thanks for you help.

Duane Hookom said:
Do all of the fields contain a value? Can you share your expression? Did
you
concatenate with "&" or "+"?
Click to expand...
Click to expand...
 
Yes. The record is fine. If I put the fields on the report individually
rather than in the field with the expression, the data shows up on the report
just fine.

Duane Hookom said:
Have you looked at the record in the datasheet view of the report's record
source?

--
Duane Hookom
MS Access MVP


felicitea said:
Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others display
just
find. Strange.

Thanks for you help.

Duane Hookom said:
Do all of the fields contain a value? Can you share your expression? Did
you
concatenate with "&" or "+"?

--
Duane Hookom
MS Access MVP


I have a report in an Access 2002 database in which one field for one
record
displays blank. The Control Source for the field on the report is an
expression containing a concatenation of several of the fields from a
table.
There is data in the fields for this record in the table. All the other
records display just fine. Any ideas why there would be difficulty
with
just
one record? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Get rid of the Trim() function since it isn't necessary. If this doesn't fix
your issue, either create a new report or create a column in your report's
record source:
FullAddress: [Address] & " " & [City] & ", " & [State] & " " & [Zip]
Use this column as the control source in your report.
--
Duane Hookom
MS Access MVP


felicitea said:
Yes. The record is fine. If I put the fields on the report individually
rather than in the field with the expression, the data shows up on the
report
just fine.

Duane Hookom said:
Have you looked at the record in the datasheet view of the report's
record
source?

--
Duane Hookom
MS Access MVP


felicitea said:
Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others display
just
find. Strange.

Thanks for you help.

:

Do all of the fields contain a value? Can you share your expression?
Did
you
concatenate with "&" or "+"?

--
Duane Hookom
MS Access MVP


I have a report in an Access 2002 database in which one field for one
record
displays blank. The Control Source for the field on the report is an
expression containing a concatenation of several of the fields from
a
table.
There is data in the fields for this record in the table. All the
other
records display just fine. Any ideas why there would be difficulty
with
just
one record? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the suggestions. I tried them with no success. I did manage to get
the problem corrected through brute force. I entered a new record for this
person and deleted the old one. The address shows up perfectly on the report
now. Go figure. Corrupted record perhaps?

Thanks again for taking the time to respond to my question.

Duane Hookom said:
Get rid of the Trim() function since it isn't necessary. If this doesn't fix
your issue, either create a new report or create a column in your report's
record source:
FullAddress: [Address] & " " & [City] & ", " & [State] & " " & [Zip]
Use this column as the control source in your report.
--
Duane Hookom
MS Access MVP


felicitea said:
Yes. The record is fine. If I put the fields on the report individually
rather than in the field with the expression, the data shows up on the
report
just fine.

Duane Hookom said:
Have you looked at the record in the datasheet view of the report's
record
source?

--
Duane Hookom
MS Access MVP


Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others display
just
find. Strange.

Thanks for you help.

:

Do all of the fields contain a value? Can you share your expression?
Did
you
concatenate with "&" or "+"?

--
Duane Hookom
MS Access MVP


I have a report in an Access 2002 database in which one field for one
record
displays blank. The Control Source for the field on the report is an
expression containing a concatenation of several of the fields from
a
table.
There is data in the fields for this record in the table. All the
other
records display just fine. Any ideas why there would be difficulty
with
just
one record? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Perhaps a corrupt record or an imbedded carriage return/line feed.

--
Duane Hookom
MS Access MVP


felicitea said:
Thanks for the suggestions. I tried them with no success. I did manage to
get
the problem corrected through brute force. I entered a new record for this
person and deleted the old one. The address shows up perfectly on the
report
now. Go figure. Corrupted record perhaps?

Thanks again for taking the time to respond to my question.

Duane Hookom said:
Get rid of the Trim() function since it isn't necessary. If this doesn't
fix
your issue, either create a new report or create a column in your
report's
record source:
FullAddress: [Address] & " " & [City] & ", " & [State] & " " & [Zip]
Use this column as the control source in your report.
--
Duane Hookom
MS Access MVP


felicitea said:
Yes. The record is fine. If I put the fields on the report
individually
rather than in the field with the expression, the data shows up on the
report
just fine.

:

Have you looked at the record in the datasheet view of the report's
record
source?

--
Duane Hookom
MS Access MVP


Yes, all the fields contain a value. Here's the expression:
=Trim([Address] & " " & [City] & ", " & [State] & " " & [Zip])

As I said, it's only a problem with one record. All the others
display
just
find. Strange.

Thanks for you help.

:

Do all of the fields contain a value? Can you share your
expression?
Did
you
concatenate with "&" or "+"?

--
Duane Hookom
MS Access MVP


I have a report in an Access 2002 database in which one field for
one
record
displays blank. The Control Source for the field on the report is
an
expression containing a concatenation of several of the fields
from
a
table.
There is data in the fields for this record in the table. All the
other
records display just fine. Any ideas why there would be
difficulty
with
just
one record? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top