fields wont show themselves

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

Trouble, Trouble with this report

I need a report to be sent to various offices.
Most of the report is text that I will enter myself, the rest are
fields to personalize the form, and blank lines for the recipient to
hand write responses in.

I generated a table creating fields to hold my text paragraphs

I then used the wizard to create a form so I could but the info into
the table (as I write this I am thinking I could probably have just
put the info directly into the table fields. Duh!!)

Then I generated a report based on the table, but none of the fields
will show themselves. In design view they are there, but when I look
at the actual report, none of them are there except the title in the
header. Can't figure it out. By rights they should be loading onto
the form and filling in with the information from the table.

Could someone please give me an idea of where to look for the answer
to this perplexing question.

Having lots of frustrated 'fun' ;- )
Joanne
 
Make sure that the Recordsource (Rowsource?) property of the report is set
to the name of the table. Make sure that the Controlsource property of each
textbix is set to the name of the relevant field in that table.

HTH,
TC
 
Thank you TC you put more info in that 3 line answer - all of it
helpful for this whole project - muchly appreciated by me
 
TC
I redid my operation in this manner
Built a query (1-1 relat) on the two tables holding my info

Wizard design of report based on this query

Design View = all controls show
Print Preview = only header and footer show
Recordsource = my query to create report
each txt and memo controlsource = it's field in the tables

Can't figure out what is going on.
Have any ideas for me to look at next?
Thanks a heap
 
Hi Joanne

I'm a bit confused by your post. Did my original suggestions fix your
problem? I thought, from your first reply, that they had. But now I'm not so
sure!

See if you can run the query directly from the query window. Take note of
the column names. Then you must use >those< names as the controlsource of
each textbox etc. on the report. Sometimes, depending on how you write the
query, the query column names will not always be the same as the names of
the fields in the table(s).

If only the report header & footer print in print preview, maybe the Visible
property of the Detail section is set to False? Or is being set to False at
runtime, by code within the report's code module?

HTH,
TC
 
Back
Top