Fields Do not Print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have never had this happen before. I created a new database with a form
attached to it. It looks fine on the screen in design and form views. In
Print Preview, the fields are all gone. All I can see is the background of
the form. When I try to print it, same thing - a blank page. I have tried
selecting all of the fields and bringing them to the front - same thing.

Now I have tried creating a new database and a form, and the same thing
happens. Any ideas?
 
I've had this happen before! With me it was a combao box that was at fault.
The solution may be a bit tedious but give it a try. Firstly, are any of your
fields combo boxes or drop down lists? Entries in a combo box or lists that
don't match the row source of the combo will cause this. Selecting a combo
box item then deleting it creates a Zero Length String or a Null value (not
sure which, its been a while) in that field. Often that will cause the
problem. (A value in your combo that doesn't match the row source) Try
selecting a value in all your combo boxes one at a time then do a print
preview of your report until your fields display data. This may show you
where the problem lies (no guarantees). Remember, one or more combos could be
at fault, so fix up the last one (until your data appears on the report) then
work your way back.

Also check that you don't have a combo box or data source with a default
value that doesn't match the row source. Hope this helps. Good luck!

data cruncher said:
I have never had this happen before.
Click to expand...
I created a new database with a form
 
Just had another thought on this one. Check your join properties on the
record source for your report. You may need to change the join properties
between your tables in the record source from 1. Only include rows where the
blah blah blah to 2. or 3. Include all records from blah, blah blah. Run the
record source query to see if it returns any data. If you don't get a return
of data start building your record source again adding one table at a time
until you find where the error lies. Good luck again!
 
Thanks, Greg,
for your two helpful posts.
I have been at a robotics competition all day (for which I am creating this
"scouting" database, and have figured out the culprit!

If there is NO data entered into the table - the darn thing doesn't show up
in print preview or on the printer. I am talking no labels, lines, nothing!
As soon as I created a "fake" record with some data in it, it showed up and
printed.

What I went on to realize was that I didn't want to use that printed form
for our scouters to use (hand write in scoring, comments, etc.) since there
was a bunch of "0"'s in the fields. So I created a report with the same
fields, and replaced them with text labels and drew in boxes for my check
boxes. Seems like there should be a better way..... maybe there is? Anyway,
this got me out of the jam, and hope someone else can benefit from this
discussion.

Thanks again.
 
Back
Top