Data on fom not displaying

Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I have
checked everything I can think of and all appears to be in order. obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview, was the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan

Why are you printing a form? Forms are not designed for printing. They CAN
be printed, but that is not their purpose. You can't control the printout
very well.

If you wish to print data from an Access database, the proper approach is to
create a REPORT and print it. You can even add a button to your form that
will print the appropriate report. The button wizard will walk you through
all the steps once your report is built and saved.

--
Rick B



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the
controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I
have
checked everything I can think of and all appears to be in order.
obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview, was
the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan

Hi Jan,
Are you talking about print previewing a Form and not a Report? If so, then
quit that (j/k).

Seriously, do page navigation buttons show at the bottom of the print
preview screen?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the
controls and now it is far within the 8.5"w paper. I am no longer getting
the message but nothing is showing up. It is set to display Always, and I
have checked everything I can think of and all appears to be in order.
obviously, I am over looking something. The only things that I added after
I last checked that it was working and was displaying in the Print
preview, was the Save record and Cancel buttons. After than, it would not
display.

Any suggestions what else I might check?

Jan

"Jan Il" wrote in message

Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a
print preview, nothing shows up except the header information which
is in a label.

It was working properly then suddenly nothing is showing up. At first
it said that the data was wider than the paper, but, I rearranged the
controls and now it is far within the 8.5"w paper. I am no longer
getting the message but nothing is showing up. It is set to display
Always, and I have checked everything I can think of and all appears
to be in order. obviously, I am over looking something. The only
things that I added after I last checked that it was working and was
displaying in the Print preview, was the Save record and Cancel
buttons. After than, it would not display.

Any suggestions what else I might check?

Hi, Jan -

First question: if you open the form normally -- that is, in form
view -- are any records displayed, not counting the blank "new record"?

Second question: when you open the form in print preview, how are you
doing it? Are you first opening the form in form view, and then
choosing Print Preview? Or are you selecting the form in the database
window and clicking Print Preview? Or are you doing it in code? If
code, please post it.

Third question: when you open the form in print preview and it shows up
blank, are there multiple pages for you to page through?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Hi Rick :-)

Why are you printing a form? Forms are not designed for printing. They
CAN
be printed, but that is not their purpose. You can't control the printout
very well.

If you wish to print data from an Access database, the proper approach is
to
create a REPORT and print it. You can even add a button to your form that
will print the appropriate report. The button wizard will walk you
through
all the steps once your report is built and saved.

Yes...I klnow....and I have fully explained this to the client. They want
to print the data from the form. I created a really nice report, but, they
want the from printed as a report.

Thank you for your time and help. :-)

Jan

--
Rick B



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the
controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I
have
checked everything I can think of and all appears to be in order.
obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview, was
the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan

Hi Lynn! :-)

" Are you talking about print previewing a Form and not a Report? If so,
then
quit that (j/k).

I know! I know! It ain't 'spose to be that way. But....the client has
their idea of how it should be. )

Seriously, do page navigation buttons show at the bottom of the print
preview screen?

No. Nothing but the label in the header.

Jan

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first it
said that the data was wider than the paper, but, I rearranged the
controls and now it is far within the 8.5"w paper. I am no longer
getting the message but nothing is showing up. It is set to display
Always, and I have checked everything I can think of and all appears to
be in order. obviously, I am over looking something. The only things that
I added after I last checked that it was working and was displaying in
the Print preview, was the Save record and Cancel buttons. After than, it
would not display.

Any suggestions what else I might check?

Jan

If it were me, I'd make the report look very very similar to the form and
add a print button to the form. The client wants to print the data, how
that is accomplished is up to the database designer, not them. You can make
it look as close to the form as you'd like, if they can't get their head
around the fact that laying out items for data entry on a screen is not as
efficient for a printed document as if you build the item specifically for
printing. Do they screenprint their emails in Oultook or do they use the
handy dandy "print" button. Do they screen print a letter in Word?



--
Rick B



"Jan Il" wrote in message
...
Hi Rick :-)

Why are you printing a form? Forms are not designed for printing. They
CAN
be printed, but that is not their purpose. You can't control the
printout
very well.

If you wish to print data from an Access database, the proper approach
is
to
create a REPORT and print it. You can even add a button to your form
that
will print the appropriate report. The button wizard will walk you
through
all the steps once your report is built and saved.

Yes...I klnow....and I have fully explained this to the client. They want
to print the data from the form. I created a really nice report, but,
they
want the from printed as a report.

Thank you for your time and help. :-)

Jan

--
Rick B



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first
it
said that the data was wider than the paper, but, I rearranged the
controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I
have
checked everything I can think of and all appears to be in order.
obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview,
was
the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan

Hi Dirk! :-)

"Jan Il" wrote in message

Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a
print preview, nothing shows up except the header information which
is in a label.

It was working properly then suddenly nothing is showing up. At first
it said that the data was wider than the paper, but, I rearranged the
controls and now it is far within the 8.5"w paper. I am no longer
getting the message but nothing is showing up. It is set to display
Always, and I have checked everything I can think of and all appears
to be in order. obviously, I am over looking something. The only
things that I added after I last checked that it was working and was
displaying in the Print preview, was the Save record and Cancel
buttons. After than, it would not display.

Any suggestions what else I might check?

Hi, Jan -

First question: if you open the form normally -- that is, in form
view -- are any records displayed, not counting the blank "new record"?

No...there are no records displayed. Only the normal blank "new record"
appearance.


Second question: when you open the form in print preview, how are you
doing it? Are you first opening the form in form view, and then
choosing Print Preview? Or are you selecting the form in the database
window and clicking Print Preview? Or are you doing it in code? If
code, please post it.

I am opening the form in Form view and all records are displayed. Then
doing the Print Preview. But, I just now tried it the other way, from the
database window and it is the same, nothing, just the header.

There is no code for this, it is just a plain, simple data entry form with
Save Record and Cancel buttons.

I have tried first copying the form details to a new form, same thing,.
Then I tried importing the form into new database, but, it is the same. I
have the database set to compact and compile on close.


Third question: when you open the form in print preview and it shows up
blank, are there multiple pages for you to page through?

No....as this is not a fully functional database as yet, the client has only
entered a few records for testing purposes so there is only one page of
data.

Thanks for you time and help :-)

Jan

I know! I know! It ain't 'spose to be that way. But....the client has
their idea of how it should be. )

Ah, clients! Can't live with them. Can't live without them...LOL.

Seriously, do page navigation buttons show at the bottom of the print
preview screen?

No. Nothing but the label in the header.

Since Dirk asked you a similar question, you might try adding some data
through the form and see if that fixes your problem.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

Hi Rick :-)

You're right, and don't argue that printing the form process is not the
right way to do things. However, I am dealing with a client who is
self -taught in Access (as in... they have been at it for two months now),
and, feel they know what they are doing and what they want. Which is, for
me to 'assist' them in creating a database for their business. I already
have the report created.....and it is like the form....and ...you can even
print a form as a report. But...I have to convince the client that their
way is not the way to do it. However, right now they want to see the form
printed their way. ;o)

I have the puce and green candles burning, and my "Worry Beads' are at
hand.....right next to the Advil and Tums....g

Jan

If it were me, I'd make the report look very very similar to the form and
add a print button to the form. The client wants to print the data, how
that is accomplished is up to the database designer, not them. You can
make
it look as close to the form as you'd like, if they can't get their head
around the fact that laying out items for data entry on a screen is not as
efficient for a printed document as if you build the item specifically for
printing. Do they screenprint their emails in Oultook or do they use the
handy dandy "print" button. Do they screen print a letter in Word?



--
Rick B



"Jan Il" wrote in message
...
Hi Rick :-)

Why are you printing a form? Forms are not designed for printing.
They
CAN
be printed, but that is not their purpose. You can't control the
printout
very well.

If you wish to print data from an Access database, the proper approach
is
to
create a REPORT and print it. You can even add a button to your form
that
will print the appropriate report. The button wizard will walk you
through
all the steps once your report is built and saved.

Yes...I klnow....and I have fully explained this to the client. They
want
to print the data from the form. I created a really nice report, but,
they
want the from printed as a report.

Thank you for your time and help. :-)

Jan

--
Rick B



"Jan Il" wrote in message
...
Hi all :-) XP Pro, Access 2003

I have an entry form for record sales activities, and when I do a
print
preview, nothing shows up except the header information which is in a
label.

It was working properly then suddenly nothing is showing up. At first
it
said that the data was wider than the paper, but, I rearranged the
controls
and now it is far within the 8.5"w paper. I am no longer getting the
message but nothing is showing up. It is set to display Always, and I
have
checked everything I can think of and all appears to be in order.
obviously,
I am over looking something. The only things that I added after I last
checked that it was working and was displaying in the Print preview,
was
the
Save record and Cancel buttons. After than, it would not display.

Any suggestions what else I might check?

Jan