Insert data into label on report

T

Tom Brown

I have a report called Approval which is bound to a table that pulls data
for Credit Applications in Access 2003. The table contains all the info
about the applicant. I have inserted the following statement on a label
on the Approval report, which is really a letter we will send the
applicant when they are Approved.
" We are happy to inform you that your application has been approved for
__________ terms."
I want to use the blank space above to pull from a column in the bound
table. I can't figure out what to use to pull the data. The terms column
in the table will coincide with the applicant who is being sent the
letter. I originally tried using a textbox but whenever I entered the
statement in the control source box it would not accept it. Can this be
done? If so, how?

Thanks,

Tom Brown
 
K

KARL DEWEY

Do not use a label but a text box with this --
= "We are happy to inform you that your application has been approved for
" & [Terms] & " terms."
 
T

Tom Brown

Thanks, Karl, that did the trick!!

KARL DEWEY said:
Do not use a label but a text box with this --
= "We are happy to inform you that your application has been approved
for
" & [Terms] & " terms."
--
KARL DEWEY
Build a little - Test a little


Tom Brown said:
I have a report called Approval which is bound to a table that pulls data
for Credit Applications in Access 2003. The table contains all the info
about the applicant. I have inserted the following statement on a label
on the Approval report, which is really a letter we will send the
applicant when they are Approved.
" We are happy to inform you that your application has been approved for
__________ terms."
I want to use the blank space above to pull from a column in the bound
table. I can't figure out what to use to pull the data. The terms column
in the table will coincide with the applicant who is being sent the
letter. I originally tried using a textbox but whenever I entered the
statement in the control source box it would not accept it. Can this be
done? If so, how?

Thanks,

Tom Brown
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Search using a combo box and then creating a report. 4
Insert Index into a Table 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Creatng If Statements with several groups 7
Creating a Chart on form from selected data in query. 0
Strange Label issue 2
Macro to automatically print current record on update to a report 5

Top