Random query swapping-Frustrating!

E

EMC Angel

Simple. Three forms in a report. Col 1, col 2, col 3. Ordered right to left.
When I look at it in design view, everything is good.
When I try to print, or look at it in print preview, what the form displays
changes.
Sometimes it'll show col 1, col 1, col 3
or col 2, col 2, col 3

another example:
two queries in one form: query A, query B
As soon as I try to print/print preview, they both become A, or they both
become B.

What is going on! And how do I stop it. There is no reason this should occur.
 
K

KARL DEWEY

What is the form display - datasheet, single form, or continous form?

In datasheet you can drag the columns and change widths to modify the diaplay.
 
D

Dirk Goldgar

EMC Angel said:
Simple. Three forms in a report. Col 1, col 2, col 3. Ordered right
to left. When I look at it in design view, everything is good.
When I try to print, or look at it in print preview, what the form
displays changes.
Sometimes it'll show col 1, col 1, col 3
or col 2, col 2, col 3

another example:
two queries in one form: query A, query B
As soon as I try to print/print preview, they both become A, or they
both become B.

What is going on! And how do I stop it. There is no reason this
should occur.
Click to expand...

It's possible this is the effect of the Name AutoCorrect misfeature.
Try going to Tools -> Options ..., General tab, and uncheck "Track name
AutoCorrect info". See if that makes a difference.
 
Top