Jegajothy vythilingam
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Bravo for thesolution.thank u
="# BYNYRGK " & " " & [EndorsementLine]
mx