Putting Fields into TextBoxes

  • Thread starter Thread starter dgrdinh
  • Start date Start date
D

dgrdinh

I have Report with the NAME: Report by Class
I have a Field with the NAME: "Name", with one of the names being
"ANDY"

When i put:

NAME

into a textbox it get "Andy" which is from the field NAME.

when I put:

=[NAME]

into the box I get "Report by Class" which is not the name of the field
but the name of the Report.

What I want to do is something like :

=[NAME] + "," + [ADDRESS]

but it keeps referencing the wrong field for name, and it cant find
address!

thanks
 
I thought someone just answered this question today or yesterday or at least
something similar.

Don't name anything name since name is the name of a property. If you can't
change the name of the field named name then go to the report's record
source and alias the name field with something like:
StudentName: [Name]
Your report can then use:
=[StudentName] + "," + [ADDRESS]
 
I have Report with the NAME: Report by Class
I have a Field with the NAME: "Name", with one of the names being
"ANDY"

When i put:

NAME

into a textbox it get "Andy" which is from the field NAME.

when I put:

=[NAME]

into the box I get "Report by Class" which is not the name of the field
but the name of the Report.

What I want to do is something like :

=[NAME] + "," + [ADDRESS]

but it keeps referencing the wrong field for name, and it cant find
address!

thanks
Click to expand...

Name is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
 
Back
Top