Auto Fill Fields in a Contract

D

Dan Goble

I have programmed with Access for several years without ever needing to
generate a report. Now I have the need but not the expertise. Heres my
problem.

I have a full page text document in the form of a contract.
There are several fields that need to be filled such as the name, amount of
sale etc.
The contract is standard and never needs to be changed. I need to cut and
paste the contract into the report and then save it so that I can do it over
and over again with different individuals. I know how to get the fields to
put in the contract but dont know how to actually create the form with the
contract in it. I tried a text box but couldnt get fields into it.
I suspect the answer is simple but cant seem to find the correct verbage to
look it up.
Thanks for any help
Dan
 
K

Ken Snell \(MVP\)

Start the report's design this way. Put textboxes on the report for all
data/information that are needed to display the contents of the report. For
textboxes that will display fixed information (not dependent upon other
information in the report), set the control source property of the textbox
to an expression that generates the fixed text:
="Your text goes here"
Or you can change the textbox to a label, and put the "Your text goes here"
string as the label's caption.

For textboxes that will display content-specific information, set the
control source of the textbox to a field in the report's record source
query.
 

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

Top