Use of Trim fxn in a report

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

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.
 
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.

Duane Hookom said:
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

RLHoneycreeper said:
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.
Click to expand...
Click to expand...
 
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.

Duane Hookom said:
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

RLHoneycreeper said:
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.
Click to expand...
Click to expand...
 
You may need to re-create the report.

--
Duane Hookom
MS Access MVP

RLHoneycreeper said:
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.

Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Thanks!! I musta changed something. Sorry about the duplicate post--it
wasn't taking it, so I retyped it--my mistake!

Duane Hookom said:
You may need to re-create the report.

--
Duane Hookom
MS Access MVP

RLHoneycreeper said:
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.

Duane Hookom said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top