473,394 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

2nd column on a Report preview (access)

72 64KB
Hi,
have a Report that creates labels. Just 6 textboxes on top of each other in the Detail section.
They are located on the left of the Report so when I open the Report I only get one column. Is it possible to have 2 columns?

Printing and Print Preview comes out correctly but opening the report does not add a second column.

Thanks
Apr 23 '20 #1

✓ answered by twinnyfo

Then have the default property for your Reports as "Print Preview". Report View does not properly show columns. I have no idea why Microsoft even has that view.

4 1330
twinnyfo
3,653 Expert Mod 2GB
Neruda,

Please help me to understand exactly what the problem is:

Printing and Print Preview comes out correctly
I'm not sure there is anything to fix if it prints correctly.

but opening the report does not add a second column.
But it prints and print preview is correct? How are you opening you report other than Printing or Print Preview? (Thus, as a side note, I will encourage every user of Access to DISABLE the EnableLayoutView property of every Form and Report in their arsenal for this very reason! If this property is enabled, it becomes the default view when opening these objects and their view is never accurate.)

Perhaps the second comments above are your solution?

Hope this hepps!
Apr 23 '20 #2
Neruda
72 64KB
Hi,
the default view property of the Report is "Report View". So when I click the Report the pop window up shows just one column.

If the default view property is "print Preview" it comes out correctly.
Apr 23 '20 #3
Neruda
72 64KB
Thanks for the tip by the way, have disabled that property in all the forms
Apr 23 '20 #4
twinnyfo
3,653 Expert Mod 2GB
Then have the default property for your Reports as "Print Preview". Report View does not properly show columns. I have no idea why Microsoft even has that view.
Apr 23 '20 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Ross Hamilton | last post by:
I have a Report that creates a Catalogue of Products we sell under various Headings eg: Books, Recordings, Health Food, Diet Foods, etc There are 82 Headings and a total of 6000+ products...
0
by: Nunya Biznas | last post by:
I have a two column report that needs to have the word "continued" appear at the top of the 2nd column if the detail records are part of the group from the previous column. I have tried using a...
2
by: amith.srinivas | last post by:
Hi all, From a word macro in VBA, I am trying to create a report in access DB. The report is based on a query with a parameter. I am using Set rpt = Application.CreateReport rpt.RecordSource =...
2
by: Andy | last post by:
Hi guys I having a problem creating a report in Access 2003 project talking to a SQL database through and ODBC connect. After hours of trying things from Access Help, MSDN and Google I still...
8
by: paii, Ron | last post by:
I have a report that is opened in preview mode, the users can view it then send it to a printer. I want to; in the same command display a dialog box with "Yes/No" to confirm the next step. How do I...
1
by: Markw | last post by:
Hi folks, I probably used the term 'report' incorrectly. Sorry for that in advance. The below code produces a 2 column web page that shows in the first column a picture and the 2nd column shows...
1
by: anon3803 | last post by:
I have a report in Access that has a lot of grouping (sometimes over 5 group headers). When I export it to Excel where more people can use it and are familiar it creates a lot of blank rows when...
2
by: TSGB | last post by:
Hi all, I need to make a report and to save space I need to be able to display the title(label) in a column report just once per page. Ex. Result from record 1 Result from...
0
by: R Paquette | last post by:
Data bank working with a questionary to a column report. Which book(s) would give such details from the begining to the end. I have the copyright and I just need to make it in informatic translation...
10
by: mrijet | last post by:
hi everybody, how can I make advanced report in access 2010? Does I need to use lookup function in access to call the data from "FORM" to "REPORT". Actually I want to make it like a preview...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.