Random query swapping-Frustrating!

[Guest]

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.

 

[Guest]

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.

 

[Dirk Goldgar]

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.

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.

 

[Guest]

It worked! I just hope it stays that way. I'll try to put the other queries
back in that I had to remove because of this.

Much appreciated!