• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

Access 2007

My OS windows 7 and I am trying to create a Label using the Report.
In one of the lines, I have the following syntax :
=("# BYNYRGK " & " " & [EndorsementLine])
but it is giving me an error.  The "EndorsementLine" is a field in the database.
Can a guru please point out what I am doing wrong. Thank u.
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try w/o parens

="# BYNYRGK " & " " & [EndorsementLine]

Use a textbox for the value, and change the name of the textBox to something other than EndorsementLine and then change the control source to the following:

="# BYNYRGK " & " " & [EndorsementLine]
Reports are funny.
Because there is no current event, you can't just reference [EndorsementLine]
It HAS to be a control on the form.
It can be hidden.
If it needs to change with each record in the report, it must be in a section (ie Detail) that changes
Once you have that control named EndorsementLine  on the report
="# BYNYRGK " & " " & me.EndorsementLine
will work
jegajothyAuthor Commented:
Bravo for thesolution.thank u

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now