Use of Trim fxn in a report

[Guest]

I can't figure out why two reports I have on the same table in the same
database aren't printing or previewing the same. The table has a number of
fields, including [Last Name] and [First Name]. I have used the control
source in a text box for "=Trim([First Name] & " " & [Last Name])" in two
reports (simple testing), but it only works in one. I have combed through
the properties but can't see how the reports are different.

 

[Duane Hookom]

Make sure the name of the control is not the name of a field. If this isn't
the problem then you might have an issue with references. Check Doug
Steele's page on reference issues at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

 

[Guest]

Unfortunately, neither seems to be the problem. (It makes no sense to me
that the references would be different for two reports in the same database
file.)

One possible clue: if I put a new text box in the report where Trim isn't
working, I get an associated label. However, a new text box in the report
with Trim working does not automatically get a label.

Make sure the name of the control is not the name of a field. If this isn't
the problem then you might have an issue with references. Check Doug
Steele's page on reference issues at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

I can't figure out why two reports I have on the same table in the same
database aren't printing or previewing the same. The table has a number
of
fields, including [Last Name] and [First Name]. I have used the control
source in a text box for "=Trim([First Name] & " " & [Last Name])" in two
reports (simple testing), but it only works in one. I have combed through
the properties but can't see how the reports are different.

 

[Guest]

Unfortunately, neither suggestion works. (Also, it makes no sense to me that
there would be a reference difference for two reports in the same database
file.)

Another possible clue: when I add a text box to the report in which Trim is
not working, I get an associated label (box); however, adding a new text box
to the other report where Trim is working does not automatically bring up a
label too.

Make sure the name of the control is not the name of a field. If this isn't
the problem then you might have an issue with references. Check Doug
Steele's page on reference issues at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

I can't figure out why two reports I have on the same table in the same
database aren't printing or previewing the same. The table has a number
of
fields, including [Last Name] and [First Name]. I have used the control
source in a text box for "=Trim([First Name] & " " & [Last Name])" in two
reports (simple testing), but it only works in one. I have combed through
the properties but can't see how the reports are different.

 

[Duane Hookom]

You may need to re-create the report.

--
Duane Hookom
MS Access MVP

Unfortunately, neither seems to be the problem. (It makes no sense to me
that the references would be different for two reports in the same
database
file.)

One possible clue: if I put a new text box in the report where Trim isn't
working, I get an associated label. However, a new text box in the report
with Trim working does not automatically get a label.

Make sure the name of the control is not the name of a field. If this
isn't
the problem then you might have an issue with references. Check Doug
Steele's page on reference issues at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

message

I can't figure out why two reports I have on the same table in the same
database aren't printing or previewing the same. The table has a
number
of
fields, including [Last Name] and [First Name]. I have used the
control
source in a text box for "=Trim([First Name] & " " & [Last Name])" in
two
reports (simple testing), but it only works in one. I have combed
through
the properties but can't see how the reports are different.

 

[Guest]

Thanks!! I musta changed something. Sorry about the duplicate post--it
wasn't taking it, so I retyped it--my mistake!

You may need to re-create the report.

--
Duane Hookom
MS Access MVP

Unfortunately, neither seems to be the problem. (It makes no sense to me
that the references would be different for two reports in the same
database
file.)

One possible clue: if I put a new text box in the report where Trim isn't
working, I get an associated label. However, a new text box in the report
with Trim working does not automatically get a label.

Make sure the name of the control is not the name of a field. If this
isn't
the problem then you might have an issue with references. Check Doug
Steele's page on reference issues at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

--
Duane Hookom
MS Access MVP

message
I can't figure out why two reports I have on the same table in the same
database aren't printing or previewing the same. The table has a
number
of
fields, including [Last Name] and [First Name]. I have used the
control
source in a text box for "=Trim([First Name] & " " & [Last Name])" in
two
reports (simple testing), but it only works in one. I have combed
through
the properties but can't see how the reports are different.